Re: pgplsql - Oracle nvl - Mailing list pgsql-general

From Christian Traber
Subject Re: pgplsql - Oracle nvl
Date
Msg-id 3F4C71E6.50506@traber-net.de
Whole thread Raw
In response to pgplsql - Oracle nvl  (Christian Traber <christian@traber-net.de>)
Responses Re: pgplsql - Oracle nvl  (darren@crystalballinc.com)
List 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
>>
>>
>
>
>
>
>


pgsql-general by date:

Previous
From: Csaba Nagy
Date:
Subject: Re: pgplsql - Oracle nvl
Next
From: Martijn van Oosterhout
Date:
Subject: Re: What is the fastest way to get a resultset