Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bsV3y-0002VT-BW for pgsql-sql@arkaria.postgresql.org; Fri, 07 Oct 2016 13:19:46 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bsV3x-0008P9-TS for pgsql-sql@arkaria.postgresql.org; Fri, 07 Oct 2016 13:19:45 +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 1bsV3w-0008Oa-OJ for pgsql-sql@postgresql.org; Fri, 07 Oct 2016 13:19:45 +0000 Received: from out5-smtp.messagingengine.com ([66.111.4.29]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bsV3p-0006kI-RS for pgsql-sql@postgresql.org; Fri, 07 Oct 2016 13:19:43 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.nyi.internal (Postfix) with ESMTP id ABC2320769; Fri, 7 Oct 2016 09:19:35 -0400 (EDT) Received: from frontend1 ([10.202.2.160]) by compute3.internal (MEProxy); Fri, 07 Oct 2016 09:19:35 -0400 DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d=aklaver.com; h=cc :content-transfer-encoding:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-sasl-enc :x-sasl-enc; s=mesmtp; bh=sDR3gWkIHer4tm7VITYV/i3+K00=; b=A6fXdR VQtZrqkbkkq3zxejO5ks+LsMBVdVR4H9WVmqRZ5pyYHXY4ntUrQOAGJw5a4BTxxx SHrPzlDp/DaBWXU3KrINF+HH33kakEgmizRgNAp+PSgLmIzn7CcGDfpuwH8VWsUv t5DeA2yY6USioJophYZk4mMfBt0PvHWQvUzXQ= DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:references :subject:to:x-sasl-enc:x-sasl-enc; s=smtpout; bh=sDR3gWkIHer4tm7 VITYV/i3+K00=; b=X+zlqdJpNRRjQZQlsodaIAS+mqW9iy+xCn3wsqsDMAJpjVz bSWNrYKPgSubtfBa0sHC8riwpGf8IERfQC+8bH32OA/UO8Icxkdkb77DojaMhyl3 THTdVqf+8NpnX8OruhJKMPpoLIIh+EW381nltl10GihadaJHMy/fV+UuO+BI= X-Sasl-enc: CUbdkjHh88VYabUdoF0yX5eKjP1N7s6QPKLPqH6NHnNE 1475846375 Received: from [192.168.1.2] (174-21-85-118.tukw.qwest.net [174.21.85.118]) by mail.messagingengine.com (Postfix) with ESMTPA id 23FA7F2985; Fri, 7 Oct 2016 09:19:35 -0400 (EDT) Subject: Re: Large Objects To: Pavel Stehule , =?UTF-8?Q?J=c3=bcrgen_Purtz?= References: <8d8248b8-8535-787b-5cb7-f081be778b70@purtz.de> Cc: postgres list From: Adrian Klaver Message-ID: Date: Fri, 7 Oct 2016 06:19:34 -0700 User-Agent: Mozilla/5.0 (X11; Linux i686; rv:45.0) Gecko/20100101 Thunderbird/45.4.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit X-Pg-Spam-Score: -2.7 (--) 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 On 10/07/2016 12:25 AM, Pavel Stehule wrote: > Hi > > 2016-10-07 9:10 GMT+02:00 Jürgen Purtz >: > > 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 See also: https://www.postgresql.org/message-id/998.1474901921%40sss.pgh.pa.us > > 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 > > > -- Adrian Klaver adrian.klaver@aklaver.com -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql