Thread: SQL 'Case When...'

Hi,

Don't know if it's possible, but how do I make the following SQL
statments right?

table
-------
name  int4
attribute text[]


select attribute[1]
from table
case when attribute[1]='yes'
     then select attribute[2] from table
     else select attribute[3] from table;

Basically, I want to compare attr[1], if true then select some fields
from table; if false then select others.

Thank you.



- Bernie

> Don't know if it's possible, but how do I make the following SQL
> statments right?
> 
> select attribute[1]
> from table
> case when attribute[1]='yes'
>      then select attribute[2] from table
>      else select attribute[3] from table;
> 
> Basically, I want to compare attr[1], if true then select some fields
> from table; if false then select others.

Try this:

select    case attribute[1]  when 'yes' then attribute[2]  else attribute[3]end
from    table;

-- 
Oliver Graf
Triestram & Partner GmbH
Kohlenstr. 55, 44795 Bochum, Germany
Phone +49 234 94375-15
Fax +49 234 452206
eMail: O.Graf@t-p.com
http://www.t-p.com