sum() bug? - Mailing list pgsql-general

From Vincent Bodenstab
Subject sum() bug?
Date
Msg-id 38C3E989.62927F08@quicknet.nl
Whole thread Raw
List pgsql-general
Hi all,

I was just wondering: when I execute the following query:

select sum(foo) from bar where column1='value_which_does_not_exist';

postgres gives me a result which consists of one row. But it shouldn't
because
that value does not exist.

Does anyone know some sort of workaround for this? I need to use this
query in
a PHP script and this result in kind off annoying.

TIA

Vincent


pgsql-general by date:

Previous
From: Chris Jones
Date:
Subject: Re: [GENERAL] RE: Help with installing 6.5.3 on RedHat6.1 - specifying template
Next
From:
Date:
Subject: Re: [GENERAL] Postgresql / Threads / Scalability