RE: [SQL] SQL 'Case When...'

2000-06-09 Thread Oliver Graf
> 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

[SQL] SQL 'Case When...'

2000-06-08 Thread Bernie Huang
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 c