Re: Adding a null - Mailing list pgsql-general

From Bob Pawley
Subject Re: Adding a null
Date
Msg-id 6C6D7EF5EBDB4CA7A37E54CE871C54DE@desktop
Whole thread Raw
In response to Adding a null  ("Bob Pawley" <rjpawley@shaw.ca>)
List pgsql-general
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


> 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

pgsql-general by date:

Previous
From: Vick Khera
Date:
Subject: Re: Bench marking performance or experience using Solid State Disk Drives (SSD) with postgres
Next
From: "Greg Sabino Mullane"
Date:
Subject: Re: postgres logs indicate errors with prepared statements, since pgbouncer was installed.