Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 607AD634669 for ; Fri, 13 Mar 2009 04:53:07 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 89692-04 for ; Fri, 13 Mar 2009 04:52:53 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from vilnius.balt.net (vilnius.balt.net [195.14.170.14]) by mail.postgresql.org (Postfix) with ESMTP id BA5BB632233 for ; Fri, 13 Mar 2009 04:52:56 -0300 (ADT) Received: from nSoft.lt (unknown [217.117.29.29]) by vilnius.balt.net (Postfix) with ESMTP id 558E53C4600; Fri, 13 Mar 2009 09:52:53 +0200 (EET) Received: from [192.168.16.104] (unknown [192.168.16.104]) by nSoft.lt (Postfix) with ESMTP id E839E12F054; Fri, 13 Mar 2009 13:13:38 +0000 (GMT) Message-ID: <49BA10D3.9070200@nsoft.lt> Date: Fri, 13 Mar 2009 09:52:51 +0200 From: Julius Tuskenis User-Agent: Thunderbird 2.0.0.19 (Windows/20081209) MIME-Version: 1.0 To: Ashish Karalkar CC: "pgsql-admin@postgresql.org" , suresh gupta Subject: Re: Query related References: <004001c9a3a9$9e715dc0$cd64290a@ind.zensar.com> <49BA0D03.3060005@synechron.com> In-Reply-To: <49BA0D03.3060005@synechron.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200903/160 X-Sequence-Number: 31660 Hello > postgres=# create table name(fn text,ln text); fn and ln could be nulls, so instead of > postgres=# select fn||' '||ln as name from name; SELECT COALESCE(fn,'')||' '||COALESCE(ln,'') from name should be used. This is because NULL||TEXT = NULL -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050