Of course there is an equivalent: the case construct.
There is some nice documentation about the available functions and
operators at:
http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=functions.html
and specifically for CASE:
http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=functions-conditional.html#AEN9698
You might also find useful to know that the NVL oracle function's
parallel in postgres is COALESCE.
HTH,
Csaba.
On Wed, 2003-09-03 at 11:00, Amin Schoeib wrote:
> Hi,
> Like I see there is no equivalent to the Oracle decode Function
> In Postgres.Is there maybe somebody who wrote decode as a
> Function?
>
> Schoeib
>
> 4Tek Gesellschaft für angewandte Informationstechnologien mbH
> Schoeib Amin
> Tel. +49 (0) 69 697688-132
> Fax. +49 (0) 69 697688-111
> http://www.4tek.de
>