Обсуждение: oracle decode()

Поиск
Список
Период
Сортировка

oracle decode()

От
Andreas Schmitz
Дата:
Hello,

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

regards,

-Andreas


--

Re: oracle decode()

От
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).

--  Richard Huxton Archonet Ltd