X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 2F72647642D for ; Sun, 2 Mar 2003 02:54:58 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 77777-07 for ; Sun, 2 Mar 2003 02:54:52 -0500 (EST) Received: from joeconway.com (63-210-180-150.skyriver.net [63.210.180.150]) by postgresql.org (Postfix) with ESMTP id 03334476500 for ; Sat, 1 Mar 2003 22:44:01 -0500 (EST) Received: from [192.168.5.3] (account jconway HELO joeconway.com) by joeconway.com (CommuniGate Pro SMTP 4.0.4) with ESMTP-TLS id 1625186; Sat, 01 Mar 2003 20:19:31 -0800 Message-ID: <3E617D7F.1010600@joeconway.com> Date: Sat, 01 Mar 2003 19:41:51 -0800 From: Joe Conway User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.2.1) Gecko/20021130 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Natasa Bulatovic Cc: pgsql-sql@postgresql.org Subject: Re: Any limitation in size for return result from SELECT? References: <002e01c2dcd9$b887b2b0$e302b782@ipp.mpg.de> In-Reply-To: <002e01c2dcd9$b887b2b0$e302b782@ipp.mpg.de> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new X-Archive-Number: 200303/41 X-Sequence-Number: 12081 Natasa Bulatovic wrote: > select col1||col2||col3||.....||col100 from table > > However, when the number of concatenated columns is bigger than 22 no > result is given back (tested in psql, as well as from pgplsql).... > > Most of these columns for the test data are NULL...Datatypes of Based on your description, I'd guess column 23 is the first null one. If you concatenate null with any value, you'll get a null result: regression=# select 'hello'; ?column? ---------- hello (1 row) regression=# select 'hello' || null; ?column? ---------- (1 row) regression=# select ('hello' || null) is null; ?column? ---------- t (1 row) HTH, Joe