Rehan Saleem <pk_re...@yahoo.com> 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'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknown) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889° -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql