Re: Oracle decode Function in Postgres

I read about that but, is there maybe somebody who wrote
A decode function so that you can export Oracle code with decode
Easily to Postgres.
I ask for that cause I am a beginner in PGPLSQL.

Thanxx

Schoeib

-----Ursprüngliche Nachricht-----
Von: Csaba Nagy [mailto:nagy(at)ecircle-ag(dot)com]
Gesendet: Mittwoch, 3. September 2003 11:37
An: Amin Schoeib
Cc: Postgres general mailing list
Betreff: Re: [GENERAL] Oracle decode Function in Postgres

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
>