Re: [SQL] how to concatenate in PostgreSQL

[Robins Tharakan]

Hi,

Probably you're looking for these set of articles.

http://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#Microsoft_SQL_Server



--
Robins

On 03/24/2012 05:13 PM, Rehan Saleem wrote:

The second article (by Ethan) has good small hints for things such as the query that you ask in this thread, when migrating from MSSQL to PostgreSQL.

hi ,
how can we concatinate these lines and execute sql command
setsql = 'select user,username, firstname '
set sql += ' lastname, cardno from table1 where userid=' + 5
exec(sqi)
where 5 is the userid from table1
thanks

smime.p7s
Description: S/MIME Cryptographic Signature