Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #13863: Select from views gives wrong results - Mailing list pgsql-bugs

From Andrew Gierth
Subject Re: BUG #13863: Select from views gives wrong results
Date
Msg-id 87si14w1tz.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to Re: BUG #13863: Select from views gives wrong results  (Dean Rasheed <dean.a.rasheed@gmail.com>)
Responses Re: BUG #13863: Select from views gives wrong results  (Dean Rasheed <dean.a.rasheed@gmail.com>)
Re: BUG #13863: Select from views gives wrong results  (Andres Freund <andres@anarazel.de>)
List pgsql-bugs
Tree view 
I think for now the following patch is best. This preserves the ability
to push degenerate HAVING clauses through an explicit GROUP BY () as
well as an implicit one, but prevents pushdown in all other cases.

Includes comment and regression test.

--
Andrew (irc:RhodiumToad)
Attachment

pgsql-bugs by date:

Previous
From: Andres Freund
Date:
Subject: Re: BUG #13891: Deparsed arbiter WHERE clauses cannot be parsed by Postgres
Next
From: Pavel Stehule
Date:
Subject: Re: Re[2]: [BUGS] Segfault in MemoryContextAlloc