Re: NULL values - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: NULL values
Date
Msg-id 20010710140858.A4043@wolff.to
Whole thread Raw
In response to NULL values  ("Mark Muffett" <markm@muffett.net>)
List pgsql-general
On Tue, Jul 10, 2001 at 06:45:29PM +0100,
  Mark Muffett <markm@muffett.net> wrote:
> A simple question:
>
> Is there a Postgresql equivalent to the Oracle NVL( ) function, which allows a SELECT statement to fill in default
valuesif a column is NULL? 

coalesce will return the first nonnull argument.

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Interfacing with MSAccess
Next
From:
Date:
Subject: Re: error handling. How to?