| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> |
| Cc: | "Martin A(dot) Marques" <martin(at)math(dot)unl(dot)edu(dot)ar>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: CHAR or VARCHAR |
| Date: | 2001-03-22 17:29:04 |
| Message-ID: | Pine.BSF.4.21.0103220927210.41849-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2001-03-22 17:31:59 | Re: Foreign key referencing subclasses. |
| Previous Message | Jason Earl | 2001-03-22 17:27:26 | Re: Birthday search. |