Re: Large Objects - Mailing list pgsql-sql

From Pavel Stehule
Subject Re: Large Objects
Date
Msg-id CAFj8pRCRGeVoa0ihxqSSWJHeHuMM8zaNBT0_StO9isSf2KBePQ@mail.gmail.com
Whole thread Raw
In response to Large Objects  (Jürgen Purtz <juergen@purtz.de>)
Responses Re: Large Objects  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-sql
Hi

2016-10-07 9:10 GMT+02:00 Jürgen Purtz <juergen@purtz.de>:
a) What is the distinction between our data type TEXT and the SQL:2011 data type CLOB which we do not support (T041)?

TEXT type is classic type - you can do any available operation directly there. You don't need special conversions.
 

b) Is there a distinction between the two Postgres data types TEXT and "CHARACTER VARYING without specifying a length" - or are they only synonym terms without different functionalities and capabilities?

TEXT and varchar are pretty same types - you cannot to set limit over TEXT type - only this is visible difference

Regards

Pavel
 

Kind regards, Jürgen




--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

pgsql-sql by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Large Objects
Next
From: Adrian Klaver
Date:
Subject: Re: Large Objects