| From: | Christian Traber <christian(at)traber-net(dot)de> |
|---|---|
| To: | Csaba Nagy <nagy(at)ecircle-ag(dot)com> |
| Cc: | Postgres general mailing list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pgplsql - Oracle nvl |
| Date: | 2003-08-27 08:55:02 |
| Message-ID: | 3F4C71E6.50506@traber-net.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I know this functions, but I do not want to change the statements in my
old application.
So I want to make the functions with the Oracle names for compatibility.
Best regards,
Christian
Csaba Nagy wrote:
>You don't need to build any function for this, you have them ready:
>http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=functions-conditional.html#AEN9753
>http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=functions-conditional.html#AEN9698
>
>Cheers,
>Csaba.
>
>On Wed, 2003-08-27 at 09:58, Christian Traber wrote:
>
>
>>Hi,
>>
>>I'll try to switch from Oracle to postgres for some small applications.
>>Is it possible to build functions like Oracle's nvl or decode with pgplsql?
>>How can I make a function like nvl that works for every datatype?
>>
>>Best regards,
>>Christian
>>
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 6: Have you searched our list archives?
>>
>> http://archives.postgresql.org
>>
>>
>
>
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Csaba Nagy | 2003-08-27 09:19:15 | Re: pgplsql - Oracle nvl |
| Previous Message | Csaba Nagy | 2003-08-27 08:43:31 | Re: pgplsql - Oracle nvl |