Re: Adding a null - Mailing list pgsql-general

From Sam Mason
Subject Re: Adding a null
Date
Msg-id 20091105182841.GV5407@samason.me.uk
Whole thread Raw
In response to Adding a null  ("Bob Pawley" <rjpawley@shaw.ca>)
List pgsql-general
On Thu, Nov 05, 2009 at 10:13:28AM -0800, Bob Pawley wrote:
> However one variable sometimes returns a null value which invariably
> gives a null answer.
>
> How can I work around this??

What do you want it to do with the NULL value?  I'm assuming you want to
use COALESCE, something like:

  COALESCE(n,0) + COALESCE(m,0)

--
  Sam  http://samason.me.uk/

pgsql-general by date:

Previous
From: "Bob Pawley"
Date:
Subject: Adding a null
Next
From: "ara.t.howard"
Date:
Subject: adding a custom tsearch parser