Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bsPHz-000246-Rp for pgsql-sql@arkaria.postgresql.org; Fri, 07 Oct 2016 07:09:51 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bsPHy-00020e-8n for pgsql-sql@arkaria.postgresql.org; Fri, 07 Oct 2016 07:09:50 +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 1bsPH1-0000y1-7F for pgsql-sql@postgresql.org; Fri, 07 Oct 2016 07:08:51 +0000 Received: from mout.kundenserver.de ([212.227.17.24]) by makus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.84_2) (envelope-from ) id 1bsPGu-0008QR-70 for pgsql-sql@postgresql.org; Fri, 07 Oct 2016 07:08:49 +0000 Received: from [192.168.178.26] ([84.165.205.46]) by mrelayeu.kundenserver.de (mreue104) with ESMTPSA (Nemesis) id 0MZls6-1bbHpH0fi2-00LSFC for ; Fri, 07 Oct 2016 09:08:41 +0200 To: pgsql-sql@postgresql.org From: =?UTF-8?Q?J=c3=bcrgen_Purtz?= Subject: Large Objects Message-ID: <8d8248b8-8535-787b-5cb7-f081be778b70@purtz.de> Date: Fri, 7 Oct 2016 09:10:41 +0200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Thunderbird/45.3.0 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit X-Provags-ID: V03:K0:ZiNUy6r2LVY+UaELhgXnfBEYMFVF9DhUgwhSKn2mjN6T+ILY0Io A8kxi6nsHE3+zQQIzCYlvAhG6IOLnOSWJE8l5ZyeGjclve0dnjySYGhk04spOJNUJ97tUVl 7ERqph2ODSCkPXtoL61O7eVpdhr/2E9MsNtLvYJQws8/heqAEXQl+W3ofvqVdQi42BbSyG5 +8XVh5qzLYrSnnTis5ffQ== X-UI-Out-Filterresults: notjunk:1;V01:K0:2qD6glw9AI0=:uc6r1dcFKZa2V3dZDpPU+Z DsOlctSDVm3TEa4vqjj8A5UImIvoXgq1YJPtXAAotC/wJOXkS7HOB/WhJTiKmwYERtDR2FelD NO/YhluYlJcISTMX3Tit1P4MD1CckxEaoj9B7iFUqf5V6KtkLXtc+wT8pbn65BgaXVDK2zkTH RzXjzswJfw45aiC2vjY+2TATLRKV4xv8Ej7I+EPh/vvqv/Ow/tvmFXTyjUSOuA8B/rD3l7VFO jeze/55N+6W9RKxEOyBZ3Dxr8UEquWeDo3gtCpGQ/i4VYs2F+LZLxxyULE12b6L0wm0gZxR75 Kd/XYDXctc8nYBhHI/jyDdJI8JHPdSYjRTOy61UM2Wd9g7hmshoqT+mMiWhRfETfrWwSCSiSZ 00K7XfY+pDuMEuh4kuwGo6evjKjAq6PZgPWNmWOBnTFtXH6/LAVaFZ3lEnsn9X9U1NIWZ3Exw JH8b9Y8k0STIbSDFA0h159KoL7JLOhbAEESt4dZBb75068DBBSXaWyfIXRt/3aLheFCxfw/AR keLEEMeSrFLDmyWI9sWvQ8fWSanCPq5+gEeKm787urP+XGGLZahUXzJ3spFfAPKtZ2vOegtig FDhLLXcNIgXU4CquDDj12C4bvettTK2u0/KDiL2bNWILGPZWeEcjmcGEhA+KQODJ6jnjz5B+u n1w86w2G2v6aq9sQZSViha5k43vole6yzycVP+YY6UECaBk9+oUqh3aNgI4xXgwLu+9b5QcA1 rb4NMYFYyv9Q70Ga X-Pg-Spam-Score: -1.9 (-) 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 a) What is the distinction between our data type TEXT and the SQL:2011 data type CLOB which we do not support (T041)? 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? 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