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

From Jeffrey Melloy
Subject Re: pgplsql - Oracle nvl
Date
Msg-id 3F4D2ECF.7020802@visualdistortion.org
Whole thread Raw
In response to pgplsql - Oracle nvl  (Christian Traber <christian@traber-net.de>)
List pgsql-general
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

Try coalesce.  The syntax is the same as nvl.

Jeff


pgsql-general by date:

Previous
From: expect
Date:
Subject: Re: The ..... worm
Next
From: Steve Crawford
Date:
Subject: Re: greek char