DECODE - Mailing list pgsql-novice

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