Re: CHAR or VARCHAR - Mailing list pgsql-sql

From Karel Zak
Subject Re: CHAR or VARCHAR
Date
Msg-id 20010322140755.A8191@ara.zf.jcu.cz
Whole thread Raw
In response to Re: CHAR or VARCHAR  ("Martin A. Marques" <martin@math.unl.edu.ar>)
Responses Re: CHAR or VARCHAR  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-sql
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  <zakkr@zf.jcu.cz>http://home.zf.jcu.cz/~zakkr/C, PostgreSQL, PHP, WWW, http://docs.linux.cz,
http://mape.jcu.cz


pgsql-sql by date:

Previous
From: "Jack"
Date:
Subject: Re: Re: psql win32 version
Next
From: "postgresql"
Date:
Subject: creating "job numbers"