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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
