[SQL] IF statement in Select

[Renato Cramer]

Hello all,

Is the use of IF statement restrict to Functions and Store Procedures?

I'm trying to use an IF within Select...

Example:
create view v1 as
select c1,
 c2,
 if c3 = 52 then 0
 else 1
 endif as base_irrf_13
 from t1;

Thanks in advance,

Renato Cramer.

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings