Re: + operator with a possible NULL operand

You're right of course!! Small glitch in my program but I think it's been
debugged now.

Sorry, ... I just got back from seeing the Matrix.

Vincent Hikida,
Member of Technical Staff - Urbana Software, Inc.
"A Personalized Learning Experience"

www.UrbanaSoft.com

----- Original Message -----
From: "Bruno Wolff III" <bruno(at)wolff(dot)to>
To: "Vincent Hikida" <vhikida(at)inreach(dot)com>
Cc: "Michael Glaesemann" <grzm(at)myrealbox(dot)com>; <pgsql-novice(at)postgresql(dot)org>
Sent: Thursday, May 29, 2003 4:16 AM
Subject: Re: [NOVICE] + operator with a possible NULL operand

> On Wed, May 28, 2003 at 23:43:19 -0700,
> Vincent Hikida <vhikida(at)inreach(dot)com> wrote:
> >
> > That is
> >
> > SELECT SUM(numvar) FROM tablex
> >
> > Will treat any numvar which are null as if they were a zero. However,
the
> > following will not treat it as zero but non-existent.
>
> Aggragates (except for count(*)) will skip any row for which the
expression
> is null. For sum() that turns out to be equivalent to treating the number
> as zero because of the way math works. But the function isn't actually
> treating nulls as zeros.
>