Re: [SQL] how to concatenate in PostgreSQL

On 3/24/12, Andreas Kretschmer wrote: > Rehan Saleem wrote: > >> hi , >> how can we concatinate these lines and execute sql command >> >>set sql = 'select user,username, firstname ' >> set sql += ' lastname, cardno from table1 where userid=' + 5 > > sql = sql || ' bla fasel'; > > ||

Re: [SQL] how to concatenate in PostgreSQL

Rehan Saleem wrote: > hi , > how can we concatinate these lines and execute sql command > >set sql = 'select user,username, firstname ' > set sql += ' lastname, cardno from table1 where userid=' + 5 sql = sql || ' bla fasel'; || is the concat - Operator. Andreas -- Really, I

[SQL] how to concatenate in PostgreSQL

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