Re: how to concatenate in PostgreSQL

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?

 

       set sql = '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