[SQL] how to concatenate in PostgreSQL

2012-03-24 Thread Rehan Saleem 
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

Re: [SQL] how to concatenate in PostgreSQL

2012-03-24 Thread Andreas Kretschmer 
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'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

Re: [SQL] how to concatenate in PostgreSQL

2012-03-24 Thread Allan Kamau 
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';
>
> || 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
>


You may want to ensure that none of variables to be concatenated is
NULL, else the end result will be NULL.
"coalesce" function provides means to provide an substitute value for
a variable that may be NULL.

Allan.

-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql