X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 1F2F0D1B565
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sat, 20 Sep 2003 17:05:45 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 04888-09
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sat, 20 Sep 2003 14:05:14 -0300 (ADT)
Received: from web60107.mail.yahoo.com (web60107.mail.yahoo.com
	[216.109.118.86])
	by svr1.postgresql.org (Postfix) with SMTP id BCB70D1B568
	for <pgsql-sql@postgresql.org>; Sat, 20 Sep 2003 14:05:12 -0300 (ADT)
Message-ID: <20030920170512.76693.qmail@web60107.mail.yahoo.com>
Received: from [61.11.18.65] by web60107.mail.yahoo.com via HTTP;
	Sat, 20 Sep 2003 10:05:12 PDT
Date: Sat, 20 Sep 2003 10:05:12 -0700 (PDT)
From: yogesh selukar <yogesh_selukar@yahoo.com>
Subject: Re: Simple concatenation in select query
To: pgsql-sql@postgresql.org, sandis@mediaparks.lv
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1297530960-1064077512=:74940"
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=1.3 tagged_above=0.0 required=5.0 tests=BAYES_30,
	HTML_30_40, RCVD_IN_NJABL, X_NJABL_OPEN_PROXY
X-Spam-Level: *
X-Archive-Number: 200309/236
X-Sequence-Number: 15214

--0-1297530960-1064077512=:74940
Content-Type: text/plain; charset=us-ascii

Hello Everybpdy,
     The concatination in select query u can write the query like this.
 
 select c.status||' this '||' is '||' the '||' status ' from course_master as c;
         This works fine
 
Regards
 
Yogesh


---------------------------------
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
--0-1297530960-1064077512=:74940
Content-Type: text/html; charset=us-ascii

<DIV>Hello Everybpdy,</DIV>
<DIV>&nbsp;&nbsp;&nbsp;&nbsp; The concatination in select query u can write the query like this.</DIV>
<DIV>&nbsp;</DIV>
<DIV><STRONG>&nbsp;select c.status||' this '||' is '||' the '||' status ' from course_master as c;</STRONG></DIV>
<DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; This works fine</DIV>
<DIV>&nbsp;</DIV>
<DIV>Regards</DIV>
<DIV>&nbsp;</DIV>
<DIV><STRONG>Yogesh</STRONG></DIV><p><hr SIZE=1>
Do you Yahoo!?<br>
<a href="http://us.rd.yahoo.com/evt=10469/*http://sitebuilder.yahoo.com">Yahoo! SiteBuilder</a> - Free, easy-to-use web site design software
--0-1297530960-1064077512=:74940--