Skip site navigation (1) Skip section navigation (2)

sum() bug?

From: Vincent Bodenstab <vincent(dot)bodenstab(at)quicknet(dot)nl>
To: pgsql-general(at)postgresql(dot)org
Subject: sum() bug?
Date: 2000-03-06 17:23:21
Message-ID: 38C3E989.62927F08@quicknet.nl (view raw or flat)
Thread:
Lists: 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


Responses

pgsql-general by date

Next:From: Chris JonesDate: 2000-03-06 18:55:12
Subject: Re: [GENERAL] database corruption?
Previous:From: Chris JonesDate: 2000-03-06 17:15:21
Subject: Re: [GENERAL] RE: Help with installing 6.5.3 on RedHat6.1 - specifying template

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group