On Tue, Sep 01, 2009 at 10:05:44AM +0100, Sam Mason wrote:
> On Mon, Aug 31, 2009 at 04:02:43PM -0700, Sheng Cheng wrote:
> > I though the following query would give me the same results in 8.4.0 and
> > 8.3.1.
>
> It should give the same results! This looks like a bug in 8.4 to me
I've just noti
On Mon, Aug 31, 2009 at 04:02:43PM -0700, Sheng Cheng wrote:
> I though the following query would give me the same results in 8.4.0 and
> 8.3.1.
It should give the same results! This looks like a bug in 8.4 to me, in
an attempt to optimize things it's pulling the CASE out from inside the
inner se
PostgreSQL version: 8.4.0 / 8.3.1
Operating system: Red Hat 4.1.1-52
Description:Aggregate function with subquery in 8.3 and 8.4.
Details:
Here are some facts and questions about the aggregate function with
subquery
in 8.3 and 8.4.
= Question 1. ==
I
