Search Postgresql Archives

Re: Abbreviation list

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux