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



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to