Re: VARCHAR vs TEXT - Mailing list pgsql-sql

From Vivek Khera
Subject Re: VARCHAR vs TEXT
Date
Msg-id 15308.16203.511887.66643@onceler.kciLink.com
Whole thread Raw
In response to Re: VARCHAR vs TEXT  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-sql
>>>>> "BM" == Bruce Momjian <pgman@candle.pha.pa.us> writes:

>> 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?

BM> TEXT limit is 1GB, as shown on the 'limits' FAQ item.  Is it worth
BM> mentioning here?  CHAR()/VARCHAR() also 1GB limit.

My personal belief is that most FAQ entries could go away if the
reference documentation had the necessary information...


pgsql-sql by date:

Previous
From: "Henshall, Stuart - WCP"
Date:
Subject: Re: problem w/plpgsql proc
Next
From: Bruce Momjian
Date:
Subject: Re: VARCHAR vs TEXT