Commit2b2cf39

committed

Update char/varchar()/text/bytea to mention they have similar performance

characteristics.

1 parent06b2979 commit2b2cf39Copy full SHA for 2b2cf39

File tree

-4

lines changed

-4

lines changed

Lines changed: 3 additions & 2 deletions

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:Thu Oct17 19:33:40 EDT 2002`
	`4`	`+ Last updated:Sat Oct19 22:58:02 EDT 2002`
`5`	`5`
`6`	`6`	`Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)`
`7`	`7`
`@@ -848,7 +848,8 @@ BYTEA bytea variable-length byte array (null-byte safe)`
`848`	`848`	`VARCHAR(n) is best when storing variable-length strings but it limits`
`849`	`849`	`how long a string can be. TEXT is for strings of unlimited length,`
`850`	`850`	`maximum 1 gigabyte. BYTEA is for storing binary data, particularly`
`851`		`- values that include NULL bytes.`
	`851`	`+ values that include NULL bytes. These types have similar performance`
	`852`	`+ characteristics.`
`852`	`853`
`853`	`854`	`4.15.1) How do I create a serial/auto-incrementing field?`
`854`	`855`

Lines changed: 3 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -14,7 +14,7 @@`
`14`	`14`	`alink="#0000ff">`
`15`	`15`	`<H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1>`
`16`	`16`
`17`		`-<P>Last updated:Thu Oct17 19:33:40 EDT 2002</P>`
	`17`	`+<P>Last updated:Sat Oct19 22:58:02 EDT 2002</P>`
`18`	`18`
`19`	`19`	`<P>Current maintainer: Bruce Momjian (<Ahref=`
`20`	`20`	`"mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</A>)<BR>`
`@@ -1068,7 +1068,8 @@ <H4><A name="4.14">4.14</A>) What is the difference between the`
`1068`	`1068`	`storing variable-length strings but it limits how long a string can`
`1069`	`1069`	`be.<SMALL>TEXT</SMALL> is for strings of unlimited length, maximum`
`1070`	`1070`	`1 gigabyte.<SMALL>BYTEA</SMALL> is for storing binary data,`
`1071`		`- particularly values that include<SMALL>NULL</SMALL> bytes.</P>`
	`1071`	`+ particularly values that include<SMALL>NULL</SMALL> bytes. These`
	`1072`	`+ types have similar performance characteristics.</P>`
`1072`	`1073`
`1073`	`1074`	`<H4><Aname="4.15.1">4.15.1</A>) How do I create a`
`1074`	`1075`	`serial/auto-incrementing field?</H4>`

Comments

(0)