Adding a null
Hi
I am trying to add two variables.
However one variable sometimes returns a null value which invariably gives a null answer.
How can I work around this??
Bob
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/
Thanks Sam
Worked perfectly.
Bob
----- Original Message -----
From: "Sam Mason" <sam@samason.me.uk>
To: <pgsql-general@postgresql.org>
Sent: Thursday, November 05, 2009 10:28 AM
Subject: Re: [GENERAL] Adding a null
Show quoted text
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/--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general