From: Dimitri Fontaine <dfontaine@hi-media.com>
To: pgsql-general@postgresql.org
Subject: Re: Abbreviation list
Date: Fri, 19 Oct 2007 22:59:54 +0200
User-Agent: KMail/1.9.7
Cc: Steve Crawford <scrawford@pinpointresearch.com>,
	Alvaro Herrera <alvherre@commandprompt.com>,
	Bruce Momjian <bruce@momjian.us>, Tom Lane <tgl@sss.pgh.pa.us>
References: <200710190402.l9J42Wp11623@momjian.us>
	<20071019193641.GQ16000@alvh.no-ip.org>
	<471913B1.4050202@pinpointresearch.com>
In-Reply-To: <471913B1.4050202@pinpointresearch.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <200710192259.54640.dfontaine@hi-media.com>

Hi,

Le Friday 19 October 2007 22:29:37 Steve Crawford, vous avez =E9crit=A0:
> > Do we use that term?  Normally for us it's "large objects".
>
> Perhaps we should add "LO" but the documentation does refer to the term
> BLOB though typically in the context of "The SQL standard defines a
> different binary string type, called BLOB..." or in the list of reserved
> words.

This topic was discussed on IRC the other day, and we seemed to conclude th=
at=20
what standard SQL refers to as CLOB and BLOB can be compared to PostgreSQL=
=20
text and bytea types with TOAST storage, which makes them out-of-line text =
or=20
binary objects.
Large Objects seems to be another beast when compared to blobs...

As I'm still pretty ignorant on the matter, though, I'd appreciate it if so=
me=20
light was to be made ;)

Regards,
=2D-=20
dim