X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id EE7749FB383 for ; Tue, 12 Sep 2006 15:46:27 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 60422-01-6 for ; Tue, 12 Sep 2006 18:42:34 +0000 (UTC) X-Greylist: delayed 00:06:40.347137 by SQLgrey- Received: from web53508.mail.yahoo.com (web53508.mail.yahoo.com [206.190.37.69]) by postgresql.org (Postfix) with SMTP id 012839FB3B9 for ; Tue, 12 Sep 2006 15:36:22 -0300 (ADT) Received: (qmail 4131 invoked by uid 60001); 12 Sep 2006 18:29:41 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=yz5hKt+8JB27FWnwwkiBzEPHYGHFitNTqXiNUlqeq4iaa574e+3lstD6smXjaba4Utpk/WWIGjcp5iMbQ0yiQ/5IavFpcyCd4IQK1+do57JpOhhnKluGeqNFyokOf9+g6rLvuc6T2agKScjUpPSfvC+2pAzHRWxjmX+QKszE/t8= ; Message-ID: <20060912182941.4129.qmail@web53508.mail.yahoo.com> Received: from [196.38.142.117] by web53508.mail.yahoo.com via HTTP; Tue, 12 Sep 2006 11:29:40 PDT Date: Tue, 12 Sep 2006 11:29:40 -0700 (PDT) From: Allan Kamau Subject: Combining output of several fields in SQL query To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200609/99 X-Sequence-Number: 23013 Hi all, This is a plain simple sql question appologies for posting it here. Am looking for a way of combining values from several fields(and introducting value separators). select field2+"_"+field1 from tableA; I've tried select field2||'_'||field1 from tableA; I get "1" as the result(which is not what I want). Allan. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com