| From: | Dimitri Fontaine <dfontaine(at)hi-media(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Cc: | Steve Crawford <scrawford(at)pinpointresearch(dot)com>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Subject: | Re: Abbreviation list |
| Date: | 2007-10-19 20:59:54 |
| Message-ID: | 200710192259.54640.dfontaine@hi-media.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ian Barwick | 2007-10-20 14:05:52 | German FAQ update |
| Previous Message | Ron Johnson | 2007-10-19 20:35:08 | Re: Abbreviation list |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Trutwin | 2007-10-19 21:03:04 | Questions about LIMIT/OFFSET |
| Previous Message | Ralph Smith | 2007-10-19 20:56:53 | Re: ERROR: Could not access status of transaction #### |