Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 09B5F173662E for ; Sat, 24 Mar 2012 08:44:15 -0300 (ADT) Received: from nm18-vm3.bullet.mail.ne1.yahoo.com ([98.138.91.148]) by magus.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1SBPOH-0007YF-U8 for pgsql-sql@postgresql.org; Sat, 24 Mar 2012 11:44:15 +0000 Received: from [98.138.90.48] by nm18.bullet.mail.ne1.yahoo.com with NNFMP; 24 Mar 2012 11:43:59 -0000 Received: from [98.138.89.164] by tm1.bullet.mail.ne1.yahoo.com with NNFMP; 24 Mar 2012 11:43:59 -0000 Received: from [127.0.0.1] by omp1020.mail.ne1.yahoo.com with NNFMP; 24 Mar 2012 11:43:59 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 510238.31396.bm@omp1020.mail.ne1.yahoo.com Received: (qmail 95305 invoked by uid 60001); 24 Mar 2012 11:43:59 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1332589439; bh=wsxpP/Ew7JbAXt/ncoGTWw+e4aS4DLNb3ZFnz3fV5kk=; h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=at+Ynguvh5a3tUJU5m480voWpa5MOC1m/W1DF+gJGSBihK6oy8U4l3Mz/7zq6DgjE44t6IWrnogwOwcy6GrnQQSIFpHasUs4PYDTOmsTvJO6Vf/MvZLilo/3x2RUp8K8GpJfu+ra9+GxsAF/anjLo6KjbHjnqJo/KpnjKZ2P5EY= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=xG55apYPMSSf968BJ6vS9VDYqjLWUPNt9XfyDNVJlJj6OtPvE2zaBEzmcS4LSzKWIUgJWbmojPMRJTFQv1f6ElbEmufY8cn/tnnkZ1SvFqauiqbtABSBk7OZn8eCdDbqN2gB2pP3iWGITirnKvmaqPubzb74RF6OWiOBSaB7SIg=; X-YMail-OSG: KRetxVEVM1ljVi7DKn6GXsHVkBKgRZzSwlvbJedPCrKHF.l AJFOmmw.ncBYLIzCPQHCitppurjTCgeGnpOCHFdX5C6j_IDEB01Xdrb7YnC. fjgxF1oDvgTq0qQMWgHoC9XkLX3cIyJNkTx8Zfd.BPbe6dYjhYZ2zVH_5Crr 4aiPoTboFxdarONNfjQXAueKy1ak3wLFv8vM9c69BHjt4fgRlh5G9yvizc81 acejbfpc5vPgFhbkgR596PCg4AwBzviFwXjJvdQ7.98PfrvtOcXyDpj_UUmy XlPjWg4WAEFwkkQ3gcvUpaY5TwxxNKYXMxvnYbkHQGMxws3sN5d2HHoD7ULn Cm61OBLM1x5Kwy.r7gQFhxftEe4epZyxWk8ZZMaIY7qQNRvNSpLRE8s0OPSK 4cVbGFozhsHQTKsvphUScMpT2xAdF67ymyN5qrT.aS.dLT0HGxApVqxCU2AU 55xvf Received: from [182.177.128.211] by web121601.mail.ne1.yahoo.com via HTTP; Sat, 24 Mar 2012 04:43:59 PDT X-Mailer: YahooMailWebService/0.8.117.340979 Message-ID: <1332589439.54415.YahooMailNeo@web121601.mail.ne1.yahoo.com> Date: Sat, 24 Mar 2012 04:43:59 -0700 (PDT) From: Rehan Saleem Reply-To: Rehan Saleem Subject: how to concatenate in PostgreSQL To: "pgsql-sql@postgresql.org" MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="-1977980688-1218263531-1332589439=:54415" X-Pg-Spam-Score: 2.4 (++) X-Archive-Number: 201203/71 X-Sequence-Number: 36466 ---1977980688-1218263531-1332589439=:54415 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable hi ,=0Ahow can we concatinate these lines and execute sql command=0A=A0=0A= =A0 =A0 =A0 =A0setsql =3D'select user,username,=0Afirstname '=0A=A0=A0=A0= =A0=A0 set sql +=3D' lastname, cardno from table1where userid=3D'+ 5 =0A=A0= =A0=A0=A0=A0 exec(sqi) =0A=A0 =A0 =A0where 5 is the userid from table1=0Ath= anks ---1977980688-1218263531-1332589439=:54415 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable

hi ,<= /div>

<= span style=3D"font-size: 10pt; font-family: 'Courier New'; ">how can we con= catinate these lines and execute sql command

set sql =3D = 'select user,username,=0Afirstname '

=0A=0A &nbs= p; set sql +=3D ' lastname, cardno from table1 where user= id=3D' + 5

=0A=0A

exec(sqi) <= o:p>

=0A=0A

where 5 is the userid from table1<= /span>

thanks

=0A=0A

&= nbsp;

=0A=0A

---1977980688-1218263531-1332589439=:54415--