Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id B147E634239
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Fri, 13 Mar 2009 04:20:02 -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 83434-07 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Fri, 13 Mar 2009 04:19:52 -0300 (ADT)
X-Greylist: delayed 00:18:10.65223 by SQLgrey-1.7.6
Received: from mailrelay.zensar.com (unknown [220.225.45.73])
	by mail.postgresql.org (Postfix) with ESMTP id AE8C163246F
	for <pgsql-admin@postgresql.org>; Fri, 13 Mar 2009 04:19:51 -0300 (ADT)
thread-index: Acmjqaw6OwQyoaB7R1S/zJ75UY2inQ==
Received: from BRIDGEHEAD.ind.zensar.com ([10.42.2.95]) by
	mailrelay.zensar.com with Microsoft SMTPSVC(6.0.3790.3959);
	Fri, 13 Mar 2009 12:32:29 +0530
Content-Transfer-Encoding: 7bit
Received: from zenmailfe.ind.zensar.com ([10.42.2.88]) by
	BRIDGEHEAD.ind.zensar.com with Microsoft SMTPSVC(6.0.3790.3959);
	Fri, 13 Mar 2009 12:32:05 +0530
Received: from BATELCWDESK1094 ([10.41.100.205]) by zenmailfe.ind.zensar.com
	with Microsoft SMTPSVC(6.0.3790.3959);
	Fri, 13 Mar 2009 12:32:05 +0530
Content-Class: urn:content-classes:message
Importance: normal
Message-ID: <004001c9a3a9$9e715dc0$cd64290a@ind.zensar.com>
From: "suresh gupta" <suresh.g@zensar.com>
To: <pgsql-admin@postgresql.org>
Subject: Query related
Date: Fri, 13 Mar 2009 12:32:05 +0530
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_003D_01C9A3D7.B7FC4830"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.4133
X-OriginalArrivalTime: 13 Mar 2009 07:02:05.0538 (UTC)
	FILETIME=[9E2DEC20:01C9A3A9]
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.101 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001, RDNS_NONE=0.1
X-Spam-Level: 
X-Archive-Number: 200903/157
X-Sequence-Number: 31657

This is a multi-part message in MIME format.

------=_NextPart_000_003D_01C9A3D7.B7FC4830
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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 =3D Suresh and LN=3DGupta the output of the query should =
be Suresh Gupta in single column.=20

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=20
Zensar Knowledge Park, Plot#5, MIDC IT Tower,=20
Kharadi, Off Nagar Road, Pune - 411014
Landline : +91-20-66453471 | +91-9890898688
Email : suresh.g@zensar.com | website: www.zensar.com=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

------=_NextPart_000_003D_01C9A3D7.B7FC4830
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.5730.13" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi Team,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I had a table with 2 fields like First =
name(FN) and=20
last name(LN). When I give a query for the records of the 2 columns,=20
they&nbsp;are displaying in 2 different columns. My requirement is to =
combine=20
both the columns in a single one. As per my knowledge there are some =
operators=20
which combine 2 columns and display together in single columns like |, =
+, etc.=20
in other databases like Oracle.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>For example FN =3D Suresh =
and&nbsp;LN=3DGupta&nbsp;the=20
output of the query should be Suresh Gupta in single =
column.&nbsp;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Is there any similar operator or method =
on=20
postgresql to get my result. Please advice.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Pgsql version is 8.1 and window version =

software.</FONT></DIV>
<DIV><BR><BR><FONT color=3Dblue>Regards,<BR></FONT><FONT =
color=3Dblue><B>G. V.=20
Suresh Gupta</B><BR></FONT>
<HR>
<B>GTS - EMEIA, Zensar Technologies </B><BR>Zensar Knowledge Park, =
Plot#5, MIDC=20
IT Tower, <BR>Kharadi, Off Nagar Road, Pune - 411014<BR>Landline :=20
+91-20-66453471 | +91-9890898688<BR>Email : <A=20
href=3D"mailto:suresh.g@zensar.com">suresh.g@zensar.com</A> | website: =
<A=20
href=3D"http://www.zensar.com">www.zensar.com</A> =
<BR></DIV><p></p><p>DISCLAIMER:<br>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. </BODY></HTML>

------=_NextPart_000_003D_01C9A3D7.B7FC4830--