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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-general by date

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