thread-index: Acmjr4IsO2Y39kH3Rv+sAFFSyhu5QQ==
Content-Class: urn:content-classes:message
Message-ID: <005401c9a3af$73bc14c0$cd64290a@ind.zensar.com>
Importance: normal
From: "suresh gupta" <suresh.g@zensar.com>
To: "Ashish Karalkar" <ashishka@synechron.com>
Cc: <pgsql-admin@postgresql.org>
References: <004001c9a3a9$9e715dc0$cd64290a@ind.zensar.com>
	<49BA0D03.3060005@synechron.com>
Subject: Re: Query related
Date: Fri, 13 Mar 2009 13:13:51 +0530
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1";
	reply-type=response
Content-Transfer-Encoding: quoted-printable

Thanks Ashish, it is working.

Regards,
G. V. Suresh Gupta
-------------------------------------------------------------------------=
-------
GTS - EMEIA, Zensar Technologies Zensar Knowledge Park, Plot#5, MIDC IT=20
Tower, Kharadi, Off Nagar Road, Pune - 411014 Landline : +91-20-66453471 =
|=20
+91-9890898688 Email : suresh.g@zensar.com | website: www.zensar.com
----- Original Message -----=20
From: "Ashish Karalkar" <ashishka@synechron.com>
To: "suresh gupta" <suresh.g@zensar.com>
Cc: <pgsql-admin@postgresql.org>
Sent: Friday, March 13, 2009 1:06 PM
Subject: Re: [ADMIN] Query related


> suresh gupta wrote:
>> Hi Team,
>>  I had a table with 2 fields like First name(FN) and last name(LN). =
When=20
>> I give a query for the records of the 2 columns, they are displaying =
in 2=20
>> 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=20
>> columns and display together in single columns like |, +, etc. in =
other=20
>> databases like Oracle.
>> For example FN =3D Suresh and LN=3DGupta the output of the query =
should be=20
>> Suresh Gupta in single column. Is there any similar operator or =
method on=20
>> 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:=20
>> 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=20
>> necessarily the views of Zensar Technologies Ltd. If you are not the=20
>> intended recipient or have received this e-mail by error, its use is=20
>> strictly prohibited, please delete the e-mail and notify the sender.=20
>> Zensar Technologies Ltd. does not accept any liability for virus =
infected=20
>> mails.
>>
> This will help you.
>
> postgres=3D# create table name(fn text,ln text);
> CREATE TABLE
> postgres=3D# insert into name values ('abc','xyz');
> INSERT 0 1
> postgres=3D# select * from name;
> fn  | ln
> -----+-----
> abc | xyz
> (1 row)
>
> postgres=3D# select fn||' '||ln as name from name;
>  name
> ---------
> abc xyz
> (1 row)
>
>
>=20


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.=20