Re: [SQL] nvl() function

2001-10-17 Thread Joel Burton
On Tue, 16 Oct 2001, Steven Dahlin wrote: > I am trying to find the equivalent in Postgresql to the Oracle sql function > nvl(). With nvl() you give two parameters. The first may be a field/column > or variable. If the value is not null then it is returned by the function. > For example the wi

[SQL] nvl() function

2001-10-17 Thread Steven Dahlin
I am trying to find the equivalent in Postgresql to the Oracle sql function nvl(). With nvl() you give two parameters. The first may be a field/column or variable. If the value is not null then it is returned by the function. For example the with query below if the :ClientParameter is passed th

Re: [SQL] nvl() function

2001-10-16 Thread Andre Schnabel
Hi Steven, you may use COALESCE. This function should have the same behaviour as Oracle's nvl. For documentation look at http://www.postgresql.org/idocs/index.php?functions-conditional.html Andre "Steven Dahlin" <[EMAIL PROTECTED]> schrieb im Newsbeitrag 9qj13u$2v5l$[EMAIL PROTECTED]">news:9q