From: | Csaba Nagy <nagy(at)ecircle-ag(dot)com> |
---|---|
To: | Amin Schoeib <aschoeib(at)4tek(dot)de> |
Cc: | Postgres general mailing list <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Oracle decode Function in Postgres |
Date: | 2003-09-03 10:29:40 |
Message-ID: | 1062584980.6781.68.camel@coppola.ecircle.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Somebody asked recently on this list the exact same style of question
about NVL, receiving the exact same style of answer, having the same
objection :)
Search in the archive (in the lat month or so) for "nvl" in the subject
to see some answers.
Cheers,
Csaba.
On Wed, 2003-09-03 at 12:25, Amin Schoeib wrote:
> 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
> >
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Ian Harding | 2003-09-03 10:36:22 | Re: Access to an element of array NEW in TCL |
Previous Message | Amin Schoeib | 2003-09-03 10:25:15 | Re: Oracle decode Function in Postgres |