Re: [SQL] how to concatenate in PostgreSQL

[Steve Crawford]

On 03/24/2012 04:43 AM, Rehan Saleem wrote:

hi ,
how can we concatinate these lines and execute sql command

In what? Psql? A PL/pgSQL function. C/Java/PHP/Python/Perl/Erlang/Lua?

       setsql = 'select user,username, firstname '
      set sql += ' lastname, cardno from table1 where userid=' + 5
      exec(sqi)
     where 5 is the userid from table1
thanks

Cheers,
Steve