Re: [SQL] oracle decode()

2004-03-03 Thread Richard Huxton
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).

[SQL] oracle decode()

2004-03-03 Thread Andreas Schmitz
Hello, is there any equivalent for ORACLEs decode() in pl/pgsql ? regards, -Andreas -- ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org