Re: VARCHAR vs TEXT

>>>>> "BM" == Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:

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

Could you add the length limitation for TEXT to the reference manual?
I searched high and low for that limit, but never found it. Also,
what's the max VARCHAR() or CHAR() I can create? Is that also 1Gb?

Thanks.

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera(at)kciLink(dot)com Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/