Thread: oracle decode()

oracle decode()

From

Andreas Schmitz

Date:

03 March 2004, 09:48:52

Hello,

is there any equivalent for ORACLEs decode() in pl/pgsql ?

regards,

-Andreas


--

Re: oracle decode()

From

Richard Huxton

Date:

03 March 2004, 11:51:22

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