Re: Wrong result with constant quals - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Wrong result with constant quals
Date
Msg-id 2198598.1667520868@sss.pgh.pa.us
Whole thread Raw
In response to Re: Wrong result with constant quals  (Vik Fearing <vik@postgresfriends.org>)
Responses Re: Wrong result with constant quals  (Vik Fearing <vik@postgresfriends.org>)
List pgsql-bugs
Vik Fearing <vik@postgresfriends.org> writes:
> I allowed for this by saying it could be a single group with no rows if 
> you preferred to look at it that way.

That is exactly what the standard says.

> This does not explain why the WHERE FALSE is being ignored and producing 
> rows.

It's not ignored, but it applies to the pre-grouping rows, of which
there aren't any to remove.  But there's still a group.

            regards, tom lane



pgsql-bugs by date:

Previous
From: Pantelis Theodosiou
Date:
Subject: Re: Wrong result with constant quals
Next
From: Vik Fearing
Date:
Subject: Re: Wrong result with constant quals