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