On Mon, 8 May 2000, D'Arcy J.M. Cain wrote:
> Thus spake Vince Vielhaber
> > On Mon, 8 May 2000, Tom Lane wrote:
> >
> > > "Mitch Vincent" <mitch@huntsvilleal.com> writes:
> > > > Is the row length limit 8k? If not, what is the row length limit?
> > >
> > > 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.
Vince.
--
==========================================================================
Vince Vielhaber -- KA8CSH email: vev@michvhf.com http://www.pop4.net128K ISDN from $22.00/mo - 56K Dialup from
$16.00/moat Pop4 Networking Online Campground Directory http://www.camping-usa.com Online Giftshop
Superstore http://www.cloudninegifts.com
==========================================================================