On Wednesday 03 March 2004 10:48, Andreas Schmitz wrote:
> Hello,
>
> is there any equivalent for ORACLEs decode() in pl/pgsql ?
Is that the function that works like CASE?
CASE WHEN x=1 THEN 'ONE' WHEN x=2 THEN 'TWO' END
See the reference manual for syntax (conditional functions/operators iirc).
-- Richard Huxton Archonet Ltd