> Or simply call text-BLOBs "textblob" of something like that.
> What does SQL-92 say about BLOBs anyway?
Nothing afaik. That is why you get different meanings and usages between database
products. I'd like to keep "text" as a useful string type. Conventionally, generic
blobs are just binary objects with not much backend support (e.g. no useful
operators other than perhaps "=").
Imo generic blobs make more sense in a system without the capability to add types;
perhaps a solution for Postgres would look a little different. At the moment, the
frontend/backend protocol is different for large objects and everything else, so
it would be difficult to transparently introduce blobs which behave identically to
types which fit within a normal tuple.
In response to
pgsql-hackers by date
|Next:||From: Cristian Gafton||Date: 1998-03-03 17:34:59|
|Subject: Re: [HACKERS] PostgreSQL - the Linux of Databases...|
|Previous:||From: Bruce Momjian||Date: 1998-03-03 16:31:00|
|Subject: Re: [HACKERS] doc troubles.|