Jean-Francois Rabasse <rabasse(at)lra(dot)ens(dot)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
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
In response to
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2001-03-08 02:07:04|
|Subject: Re: seq scan on a table whereas an index exist |
|Previous:||From: Tom Lane||Date: 2001-03-08 00:38:30|
|Subject: Re: COBOL |