X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id E108A475B99 for ; Sat, 1 Mar 2003 22:40:40 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 80100-08 for ; Sat, 1 Mar 2003 22:40:39 -0500 (EST) Received: from wolff.to (wolff.to [66.93.249.74]) by postgresql.org (Postfix) with SMTP id BB8F64880B4 for ; Sat, 1 Mar 2003 22:30:47 -0500 (EST) Received: (qmail 17917 invoked by uid 500); 2 Mar 2003 03:44:36 -0000 Date: Sat, 1 Mar 2003 21:44:36 -0600 From: Bruno Wolff III To: Natasa Bulatovic Cc: pgsql-sql@postgresql.org Subject: Re: Any limitation in size for return result from SELECT? Message-ID: <20030302034436.GA17897@wolff.to> Mail-Followup-To: Natasa Bulatovic , pgsql-sql@postgresql.org References: <002e01c2dcd9$b887b2b0$e302b782@ipp.mpg.de> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <002e01c2dcd9$b887b2b0$e302b782@ipp.mpg.de> User-Agent: Mutt/1.3.25i X-Virus-Scanned: by amavisd-new X-Archive-Number: 200303/37 X-Sequence-Number: 12077 On Tue, Feb 25, 2003 at 15:25:17 +0100, Natasa Bulatovic wrote: > > select col1||col2||col3||.....||col100 from table > > Most of these columns for the test data are NULL...Datatypes of columns are mixed text, varchar, char...Select statement does not return any error...Just returns a row with a null result.... If you concatenate null with another string you get null, not the other string. You need to use coalesce to convert nulls to empty strings.