Hi,
How does one do the equivalence of Oracle's DECODE in PostgreSQL?
select
decode (v.media, 'V', 'VHS', 'L', 'Laser Disk', 'Unknown')
from
videos v
;
(ie. if (v.media == 'V') return 'VHS';
elsif (v.media == 'L') return 'Laser Disk';
else return 'Unknown'; )
thanks
dlink