Re: Proposal: QUALIFY clause - Mailing list pgsql-hackers

From Vik Fearing
Subject Re: Proposal: QUALIFY clause
Date
Msg-id 88d8f6c9-d19d-4cee-bbc5-826987c14587@postgresfriends.org
Whole thread Raw
In response to Re: Proposal: QUALIFY clause  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 21/07/2025 16:41, Tom Lane wrote:
> Isaac Morland <isaac.morland@gmail.com> writes:
>> I'll be honest, I'm skeptical that we need another keyword that basically
>> means “WHERE, but applied at a different point in the query processing”.
> That was my reaction too.  I'm especially skeptical that getting out
> front of the SQL standards committee is a good thing to do.  If and
> when this shows up in the standard, then sure.


It's "when", not "if".  I submitted a paper for this to the committee 
two years ago, but it was just a discussion paper and not an actual 
change proposal.  I have recently revived that paper so hopefully it 
will be accepted within the next year.  I would even like to push so 
that we have it in 19.

-- 

Vik Fearing




pgsql-hackers by date:

Previous
From: Masahiko Sawada
Date:
Subject: Re: Parallel heap vacuum
Next
From: Nathan Bossart
Date:
Subject: Re: Verify predefined LWLocks tranches have entries in wait_event_names.txt