nvl() function - Mailing list pgsql-sql

From Steven Dahlin
Subject nvl() function
Date
Msg-id 9qj13u$2v5l$1@news.tht.net
Whole thread Raw
Responses Re: nvl() function  (Joel Burton <joel@joelburton.com>)
List pgsql-sql
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 then only
those rows which have a clientdesc matching the parameter are returned.  If
the :ClientParameter is null then those rows which have clientdesc =
clientdesc are returned (all rows):

select        clientid,                clientdescfrom         clientswhere       ( clientdesc     = nvl(
:ClientParameter,clientdesc ) )
 

I have looked thru all the documentation I could find but nowhere were any
built-in SQL functions delineated.  Does anyone know where the documentation
can be found?

Thanks,
Steve




pgsql-sql by date:

Previous
From: "Kusuma"
Date:
Subject: Re: Performance problems - Indexes and VACUUM
Next
From: Masaru Sugawara
Date:
Subject: Re: Why would this slow the query down so much?