Re: Re: 7.2 items

On Wed, 27 Jun 2001, Hannu Krosing wrote:

> Bruce Momjian wrote:
> > 
> > > Bruce Momjian wrote:
> > > >
> > > > > Please, consider a BLOB column type without having to do lo_import,
> > > > > lo_export.
> > > >
> > > > Yep, big needed item.
> > >
> > > as we have now and unlimited rowlength it seems to be more of an
> > > interface issue than the actual implementation one (mod seek/read).
> > >
> > > Is there an ISO/ANSI SQL interface to BLOB's defined someplace ?
> > 
> > Yes, clearly interface.  Someone is working on code to insert/export
> > binary stuff using bytea and base64 encoding.  Seems like a good idea.
> 
> Will there also be support current file-like BLOB ops like seek and 
> read(n) ?

Sure, via substring().  Unfortunately, TOASTed tuple must be detoasted
completely, and you cannot get any performance boost by, for example,
reading first 8k out of a 500k bytea value. All 500k must be detoasted
first.

-alex