From cdd4379394689182d9e39c6269716c99011f60d4 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Sat, 13 Oct 2001 01:32:47 +0000 Subject: [PATCH] Update FAQ. --- doc/FAQ | 8 +++++++- doc/src/FAQ/FAQ.html | 8 +++++++- 2 files changed, 14 insertions(+), 2 deletions(-) diff --git a/doc/FAQ b/doc/FAQ index 72c208db15..09ea0c98db 100644 --- a/doc/FAQ +++ b/doc/FAQ @@ -1,7 +1,7 @@ Frequently Asked Questions (FAQ) for PostgreSQL - Last updated: Sat Sep 22 20:07:41 EDT 2001 + Last updated: Fri Oct 12 21:32:36 EDT 2001 Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) @@ -790,6 +790,12 @@ BYTEA bytea variable-length byte array (null-safe) data types are also subject to compression or being stored out-of-line by TOAST, so the space on disk might also be less than expected. + CHAR() is best when storing strings that are usually the same length. + VARCHAR() is best when storing variable-length strings, but you want + to limit how long a string can be. TEXT is for strings of unlimited + length, maximum 1 gigabyte. BYTEA is for storing binary data, + particularly values that include NULL bytes. + 4.16.1) How do I create a serial/auto-incrementing field? PostgreSQL supports a SERIAL data type. It auto-creates a sequence and diff --git a/doc/src/FAQ/FAQ.html b/doc/src/FAQ/FAQ.html index 143bb65115..ac94a0e0bb 100644 --- a/doc/src/FAQ/FAQ.html +++ b/doc/src/FAQ/FAQ.html @@ -12,7 +12,7 @@ alink="#0000FF">

Frequently Asked Questions (FAQ) for PostgreSQL

-

Last updated: Sat Sep 22 20:07:41 EDT 2001

+

Last updated: Fri Oct 12 21:32:36 EDT 2001

Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)
@@ -1003,6 +1003,12 @@ BYTEA bytea variable-length byte array (null-safe) stored out-of-line by TOAST, so the space on disk might also be less than expected.

+

CHAR() is best when storing strings that are usually the + same length. VARCHAR() is best when storing variable-length strings, + but you want to limit how long a string can be. TEXT is for strings + of unlimited length, maximum 1 gigabyte. BYTEA is for storing + binary data, particularly values that include NULL bytes.

+

4.16.1) How do I create a serial/auto-incrementing field?

-- 2.49.0