Re: 7.0 key features

From: darcy(at)druid(dot)net (D'Arcy J(dot)M(dot) Cain)
To: vev(at)michvhf(dot)com (Vince Vielhaber)
Cc: pgsql-hackers(at)hub(dot)org
Subject: Re: 7.0 key features
Date: 2000-05-08 22:15:47
Message-ID: m12ovoZ-000AXbC@druid.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Thus spake Vince Vielhaber
> > > > Well, it's BLCKSZ less some overhead --- BLCKSZ is 8K in a stock
> > > > installation ...
> > >
> > > A text datatype isn't limited to that too, is it?
> >
> > It would kind of have to be, wouldn't it, if the row it had to fit in
> > had that limit?
>
> BLOBs aren't. Or did I miss something somewhere? I've always understood
> the text datatype to be simply a text version of a BLOB. Not necessarily
> in Postgres, but elsewhere.

You mean text FILES, not datatype. There is a base type called text
which has to fit in the row so it is naturally limited to the row size.

--
D'Arcy J.M. Cain <darcy(at){druid|vex}.net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2000-05-08 22:50:25 Re: You're on SecurityFocus.com for the cleartext passwords.
Previous Message Hannu Krosing 2000-05-08 21:49:21 Re: TEXT question... Was 7.0 key features