Received: from yertle.kciLink.com (yertle.kcilink.com [216.194.193.105]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9GE8FP51413 for ; Tue, 16 Oct 2001 10:08:15 -0400 (EDT) (envelope-from khera@kciLink.com) Received: from onceler.kciLink.com (onceler.kciLink.com [216.194.193.106]) by yertle.kciLink.com (Postfix) with ESMTP id ADB552E461 for ; Tue, 16 Oct 2001 10:08:11 -0400 (EDT) Received: (from khera@localhost) by onceler.kciLink.com (8.11.6/8.11.6) id f9GE8BJ62139; Tue, 16 Oct 2001 10:08:11 -0400 (EDT) (envelope-from khera) From: Vivek Khera MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-ID: <15308.16203.511887.66643@onceler.kciLink.com> Date: Tue, 16 Oct 2001 10:08:11 -0400 To: pgsql-sql@postgresql.org Subject: Re: VARCHAR vs TEXT In-Reply-To: <200110161256.f9GCu4P07329@candle.pha.pa.us> References: <200110161256.f9GCu4P07329@candle.pha.pa.us> X-Mailer: VM 6.96 under 21.1 (patch 14) "Cuyahoga Valley" XEmacs Lucid X-Archive-Number: 200110/206 X-Sequence-Number: 5161 >>>>> "BM" == Bruce Momjian 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...