From: Ashish Karalkar <ashishka@synechron.com>
To: suresh gupta <suresh.g@zensar.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Query related
Date: Fri, 13 Mar 2009 13:06:35 +0530
Message-ID: <49BA0D03.3060005@synechron.com> (raw)
In-Reply-To: <004001c9a3a9$9e715dc0$cd64290a@ind.zensar.com>
References: <004001c9a3a9$9e715dc0$cd64290a@ind.zensar.com>
suresh gupta wrote:
> Hi Team,
>
> I had a table with 2 fields like First name(FN) and last name(LN).
> When I give a query for the records of the 2 columns, they are
> displaying in 2 different columns. My requirement is to combine both
> the columns in a single one. As per my knowledge there are some
> operators which combine 2 columns and display together in single
> columns like |, +, etc. in other databases like Oracle.
> For example FN = Suresh and LN=Gupta the output of the query should be
> Suresh Gupta in single column.
>
> Is there any similar operator or method on postgresql to get my
> result. Please advice.
>
> Pgsql version is 8.1 and window version software.
>
>
> Regards,
> *G. V. Suresh Gupta*
> ------------------------------------------------------------------------
> *GTS - EMEIA, Zensar Technologies *
> Zensar Knowledge Park, Plot#5, MIDC IT Tower,
> Kharadi, Off Nagar Road, Pune - 411014
> Landline : +91-20-66453471 | +91-9890898688
> Email : suresh.g@zensar.com <mailto:suresh.g@zensar.com> | website:
> www.zensar.com <http://www.zensar.com;
>
> DISCLAIMER:
> This email may contain confidential or privileged information for the
> intended recipient(s) and the views expressed in the same are not
> necessarily the views of Zensar Technologies Ltd. If you are not the
> intended recipient or have received this e-mail by error, its use is
> strictly prohibited, please delete the e-mail and notify the sender.
> Zensar Technologies Ltd. does not accept any liability for virus
> infected mails.
>
This will help you.
postgres=# create table name(fn text,ln text);
CREATE TABLE
postgres=# insert into name values ('abc','xyz');
INSERT 0 1
postgres=# select * from name;
fn | ln
-----+-----
abc | xyz
(1 row)
postgres=# select fn||' '||ln as name from name;
name
---------
abc xyz
(1 row)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ashishka@synechron.com, suresh.g@zensar.com
Subject: Re: Query related
In-Reply-To: <49BA0D03.3060005@synechron.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox