public inbox for [email protected]
help / color / mirror / Atom feedFrom: Tom Lane <[email protected]>
To: David Rowley <[email protected]>
Cc: Richard Guo <[email protected]>
Cc: Daniel Farkaš <[email protected]>
Cc: Magnus Hagander <[email protected]>
Cc: PostgreSQL mailing lists <[email protected]>
Subject: Re: BUG #17502: View based on window functions returns wrong results when queried
Date: Mon, 29 Jun 2026 22:27:05 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAApHDvoxZCwf7js-Xc5L=3HV65VVOOAoNm=SeTpXG9sZhR5NJQ@mail.gmail.com>
References: <[email protected]>
<CABUevEz7t3OWxaSSVSHOxa5KcYioOk=yRwoL3iMViyZQ8m2wAw@mail.gmail.com>
<CAGckUK2GLF=d9J5ErEWgK5x8ECqCw4equnq3jEzrqtfJw+iHYw@mail.gmail.com>
<CAApHDvoR4BXm7oxSrYhpEAFOZ-qMPkkYnn14y6sxtPf=5w5OOw@mail.gmail.com>
<CAApHDvqKO00nNQtchBs65VTfjEMUsYiB5r2P4VUreTdXE9RY1g@mail.gmail.com>
<CAMbWs48yS=f8tj6zstiMd6yfV3U4YpssyB55PXqjcLUyUA5bww@mail.gmail.com>
<[email protected]>
<CAApHDvoxZCwf7js-Xc5L=3HV65VVOOAoNm=SeTpXG9sZhR5NJQ@mail.gmail.com>
David Rowley <[email protected]> writes:
> On Tue, 31 Jan 2023 at 11:53, Tom Lane <[email protected]> wrote:
>> This bug seems to have slipped off the radar screen, but it's still
>> a bug. I continue to believe that the best fix is to disallow SRFs
>> in window definitions, and present the trivial patch to do so.
>> As discussed, I'm comfortable with leaving this alone in the back
>> branches.
> There has been another report about this in bug #19535. Should we
> consider going with disallowing SRFs in the WindowClause for v19?
Yeah, that slipped off the radar screen *again*. Let's disallow
SRFs in WindowClauses in HEAD and v19, and see if anyone complains.
regards, tom lane
view thread (18+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: BUG #17502: View based on window functions returns wrong results when queried
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox