Re: Large Objects - Mailing list pgsql-sql

From Thomas Kellerer
Subject Re: Large Objects
Date
Msg-id nt8tpv$bp$1@blaine.gmane.org
Whole thread Raw
In response to Re: Large Objects  (Jürgen Purtz <juergen@purtz.de>)
List pgsql-sql
Jürgen Purtz schrieb am 07.10.2016 um 21:31:
> - Types a) and b) are named identical in the standard and in Postgres
> (CHAR/VARCHAR). Data type c) is named CLOB in the standard and TEXT
> in Postgres.

>Why this different wording, if there is no real
> difference between the terms?

I guess because of historical reasons.

But if you need CLOB, then just define it:
  create domain clob as text;  create table foo (id integer, c1 clob);

Although I do agree that it would make sense to create CLOB as an alias for text and BLOB an alias for bytea.




pgsql-sql by date:

Previous
From: Jürgen Purtz
Date:
Subject: Re: Large Objects
Next
From: Adelo Herrero Pérez
Date:
Subject: Re: How to get the position of each record in a SELECT statement