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....functions.html
and specifically for CASE:
http://www.postgresql.org/docs/view....l.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
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org