Re: BUG #17502: View based on window functions returns wrong results when queried

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: David Rowley <dgrowleyml@gmail.com>
Cc: Daniel Farkaš <daniel.farkas@datoris.com>, Magnus Hagander <magnus@hagander.net>, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Date: 2022-05-30T02:45:00Z
Lists: 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



Commits

  1. Disallow set-returning functions within window OVER clauses.