From: | Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> |
---|---|
To: | "Martin A(dot) Marques" <martin(at)math(dot)unl(dot)edu(dot)ar> |
Cc: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: CHAR or VARCHAR |
Date: | 2001-03-22 13:07:55 |
Message-ID: | 20010322140755.A8191@ara.zf.jcu.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/
C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz
From | Date | Subject | |
---|---|---|---|
Next Message | postgresql | 2001-03-22 13:19:03 | creating "job numbers" |
Previous Message | Joel Burton | 2001-03-22 12:14:51 | String REPLACE function |