From: Dimitri Fontaine <dfontaine@hi-media.com>
To: pgsql-general@postgresql.org
Cc: Steve Crawford <scrawford@pinpointresearch.com>
Cc: Alvaro Herrera <alvherre@commandprompt.com>
Cc: Bruce Momjian <bruce@momjian.us>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Subject: Re: Abbreviation list
Date: Fri, 19 Oct 2007 22:59:54 +0200
Message-ID: <200710192259.54640.dfontaine@hi-media.com> (raw)
In-Reply-To: <471913B1.4050202@pinpointresearch.com>
References: <200710190402.l9J42Wp11623@momjian.us>
<20071019193641.GQ16000@alvh.no-ip.org>
<471913B1.4050202@pinpointresearch.com>
Hi,
Le Friday 19 October 2007 22:29:37 Steve Crawford, vous avez écrit :
> > 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 that
what standard SQL refers to as CLOB and BLOB can be compared to PostgreSQL
text and bytea types with TOAST storage, which makes them out-of-line text or
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 some
light was to be made ;)
Regards,
--
dim
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: dfontaine@hi-media.com, pgsql-general@postgresql.org, scrawford@pinpointresearch.com, alvherre@commandprompt.com, bruce@momjian.us, tgl@sss.pgh.pa.us
Subject: Re: Abbreviation list
In-Reply-To: <200710192259.54640.dfontaine@hi-media.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox