Re: CHAR or VARCHAR - Mailing list pgsql-sql

From Stephan Szabo
Subject Re: CHAR or VARCHAR
Date
Msg-id Pine.BSF.4.21.0103220927210.41849-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Re: CHAR or VARCHAR  (Karel Zak <zakkr@zf.jcu.cz>)
List pgsql-sql
On Thu, 22 Mar 2001, Karel Zak wrote:

> 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'.

True, but in a practical sense, even 10M or so is probably
pushing your luck unless you've got alot of ram.



pgsql-sql by date:

Previous
From: Jason Earl
Date:
Subject: Re: Birthday search.
Next
From: Stephan Szabo
Date:
Subject: Re: Foreign key referencing subclasses.