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
-
Disallow set-returning functions within window OVER clauses.
- 1de468099d27 master landed
- 0c15b715c651 19 (unreleased) landed