Re: Pbm with aggregates on empty output - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Pbm with aggregates on empty output
Date
Msg-id 22525.984012160@sss.pgh.pa.us
Whole thread Raw
In response to Pbm with aggregates on empty output  (Jean-Francois Rabasse <rabasse@lra.ens.fr>)
List pgsql-bugs
Jean-Francois Rabasse <rabasse@lra.ens.fr> writes:
>    => select sum(1) from thetable where thevalue > 10000;
>    pqReadData() -- backend closed the channel unexpectedly.

Strange ... but rather than spend any time debugging 6.5.3,
I'd suggest updating to 7.0.3.  We've fixed an awful lot of bugs
since then.

BTW, what you will actually get is a NULL result, not a zero result.
Don't blame me, blame SQL92, because that's what it specifies for SUM
of no rows :-(

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: COBOL
Next
From: Tom Lane
Date:
Subject: Re: seq scan on a table whereas an index exist