Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bsb2o-0005Bt-BP for pgsql-sql@arkaria.postgresql.org; Fri, 07 Oct 2016 19:42:58 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bsb2n-0007Tm-Di for pgsql-sql@arkaria.postgresql.org; Fri, 07 Oct 2016 19:42:57 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bsb2m-0007TP-Mt for pgsql-sql@postgresql.org; Fri, 07 Oct 2016 19:42:56 +0000 Received: from [195.159.176.226] (helo=blaine.gmane.org) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1bsb2f-0005TX-OM for pgsql-sql@postgresql.org; Fri, 07 Oct 2016 19:42:55 +0000 Received: from list by blaine.gmane.org with local (Exim 4.84_2) (envelope-from ) id 1bsb2F-0007zC-5s for pgsql-sql@postgresql.org; Fri, 07 Oct 2016 21:42:23 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-sql@postgresql.org From: Thomas Kellerer Subject: Re: Large Objects Date: Fri, 7 Oct 2016 21:41:51 +0200 Lines: 16 Message-ID: References: <8d8248b8-8535-787b-5cb7-f081be778b70@purtz.de> <95bef507-ed75-2ca9-7914-2a243d326ab3@purtz.de> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@blaine.gmane.org User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.21) Gecko/20090302 Thunderbird/2.0.0.21 Mnenhy/0.7.5.666 In-Reply-To: <95bef507-ed75-2ca9-7914-2a243d326ab3@purtz.de> X-Host-Lookup-Failed: Reverse DNS lookup failed for 195.159.176.226 (failed) X-Pg-Spam-Score: -1.1 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org 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. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql