Re: how to concatenate in PostgreSQL

Hi,

Probably you're looking for these set of articles.

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

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.

--
Robins

On 03/24/2012 05:13 PM, Rehan Saleem wrote:
> 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
>