Re: BUG #17502: View based on window functions returns wrong results when queried - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #17502: View based on window functions returns wrong results when queried
Date
Msg-id 3727090.1653878700@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #17502: View based on window functions returns wrong results when queried  (David Rowley <dgrowleyml@gmail.com>)
Responses Re: BUG #17502: View based on window functions returns wrong results when queried
List pgsql-bugs
David Rowley <dgrowleyml@gmail.com> writes:
> On Mon, 30 May 2022 at 14:19, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> I was sort of wondering why we allow SRFs in this context in the
>> first place.  The results don't seem terribly well-defined to me.

> Do you think it would fly to add such a restriction in the backbranches?

We could leave it alone in the back branches on the grounds that if
you like the results you get, we shouldn't break it in a minor
release.

            regards, tom lane



pgsql-bugs by date:

Previous
From: David Rowley
Date:
Subject: Re: BUG #17502: View based on window functions returns wrong results when queried
Next
From: David Rowley
Date:
Subject: Re: BUG #17502: View based on window functions returns wrong results when queried