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: | Raw Message | Whole Thread | 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 |