| From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Large Objects |
| Date: | 2016-10-07 07:24:05 |
| Message-ID: | nt7iij$sac$1@blaine.gmane.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
> a) What is the distinction between our data type TEXT and the SQL:2011 data type CLOB which we do not support (T041)?
I'd say there is no difference.
> 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?
No there is no difference.
Quote from the manual [1]
> Tip: There is no performance difference among these three types,
> apart from increased storage space when using the blank-padded type
Thomas
[1] https://www.postgresql.org/docs/current/static/datatype-character.html
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2016-10-07 07:25:20 | Re: Large Objects |
| Previous Message | Jürgen Purtz | 2016-10-07 07:10:41 | Large Objects |