Received: from ara.zf.jcu.cz (ara.zf.jcu.cz [160.217.161.4]) by mail.postgresql.org (8.11.3/8.11.1) with ESMTP id f2MD8Pt55600 for ; Thu, 22 Mar 2001 08:08:25 -0500 (EST) (envelope-from zakkr@zf.jcu.cz) Received: (from zakkr@localhost) by ara.zf.jcu.cz (8.9.3/8.9.3/Debian 8.9.3-21) id OAA08377; Thu, 22 Mar 2001 14:07:56 +0100 Date: Thu, 22 Mar 2001 14:07:55 +0100 From: Karel Zak To: "Martin A. Marques" Cc: Stephan Szabo , pgsql-sql@postgresql.org Subject: Re: CHAR or VARCHAR Message-ID: <20010322140755.A8191@ara.zf.jcu.cz> References: <01032208051900.07158@math.unl.edu.ar> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii User-Agent: Mutt/1.0.1i In-Reply-To: <01032208051900.07158@math.unl.edu.ar>; from martin@math.unl.edu.ar on Thu, Mar 22, 2001 at 08:05:19AM -0300 X-Archive-Number: 200103/440 X-Sequence-Number: 2108 On Thu, Mar 22, 2001 at 08:05:19AM -0300, Martin A. Marques wrote: > > > > In 7.1(currently in beta), long values can be stored > > outside that so you have more of a number of columns > > limit rather than a per value limit. Technically, > > it's probably still not a great idea to be sticking > > megs in there for performance reasons. > > I can't believe that there is no limit. You mean that I put this: > > VARCHAR(1000000000000000000000000000000000) ...length for type 'varchar' cannot exceed 10485760. But "no limit" means 'text'. Karel -- Karel Zak http://home.zf.jcu.cz/~zakkr/ C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz