Re: Large Objects

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: Large Objects
Дата
Msg-id CAFj8pRCRGeVoa0ihxqSSWJHeHuMM8zaNBT0_StO9isSf2KBePQ@mail.gmail.com
обсуждение исходный текст
Ответ на Large Objects  (Jürgen Purtz <juergen@purtz.de>)
Ответы Re: Large Objects
Список 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 по дате отправления: