Commitcdd4379

committed

Update FAQ.

1 parent0818073 commitcdd4379Copy full SHA for cdd4379

File tree

+14

-2

lines changed

+14

-2

lines changed

Lines changed: 7 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -1,7 +1,7 @@`
`1`	`1`
`2`	`2`	`Frequently Asked Questions (FAQ) for PostgreSQL`
`3`	`3`
`4`		`- Last updated:Sat Sep 22 20:07:41 EDT 2001`
	`4`	`+ Last updated:Fri Oct 12 21:32:36 EDT 2001`
`5`	`5`
`6`	`6`	`Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)`
`7`	`7`
`@@ -790,6 +790,12 @@ BYTEA bytea variable-length byte array (null-safe)`
`790`	`790`	`data types are also subject to compression or being stored out-of-line`
`791`	`791`	`by TOAST, so the space on disk might also be less than expected.`
`792`	`792`
	`793`	`+ CHAR() is best when storing strings that are usually the same length.`
	`794`	`+ VARCHAR() is best when storing variable-length strings, but you want`
	`795`	`+ to limit how long a string can be. TEXT is for strings of unlimited`
	`796`	`+ length, maximum 1 gigabyte. BYTEA is for storing binary data,`
	`797`	`+ particularly values that include NULL bytes.`
	`798`	`+`
`793`	`799`	`4.16.1) How do I create a serial/auto-incrementing field?`
`794`	`800`
`795`	`801`	`PostgreSQL supports a SERIAL data type. It auto-creates a sequence and`

Lines changed: 7 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -12,7 +12,7 @@`
`12`	`12`	`alink="#0000FF">`
`13`	`13`	`<H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1>`
`14`	`14`
`15`		`-<P>Last updated:Sat Sep 22 20:07:41 EDT 2001</P>`
	`15`	`+<P>Last updated:Fri Oct 12 21:32:36 EDT 2001</P>`
`16`	`16`
`17`	`17`	`<P>Current maintainer: Bruce Momjian (<Ahref=`
`18`	`18`	`"mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</A>)<BR>`
`@@ -1003,6 +1003,12 @@ <H4><A name="4.15">4.15</A>) What is the difference between the`
`1003`	`1003`	`stored out-of-line by<SMALL>TOAST</SMALL>, so the space on disk`
`1004`	`1004`	`might also be less than expected.</P>`
`1005`	`1005`
	`1006`	`+<P>CHAR() is best when storing strings that are usually the`
	`1007`	`+ same length. VARCHAR() is best when storing variable-length strings,`
	`1008`	`+ but you want to limit how long a string can be. TEXT is for strings`
	`1009`	`+ of unlimited length, maximum 1 gigabyte. BYTEA is for storing`
	`1010`	`+ binary data, particularly values that include NULL bytes.</P>`
	`1011`	`+`
`1006`	`1012`	`<H4><Aname="4.16.1">4.16.1</A>) How do I create a`
`1007`	`1013`	`serial/auto-incrementing field?</H4>`
`1008`	`1014`

Comments

(0)