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

From Andrew Dunstan
Subject Re: Proposal: QUALIFY clause
Date
Msg-id 6bcb5472-194e-4813-8bed-8719c492f6f2@dunslane.net
Whole thread Raw
In response to Re: Proposal: QUALIFY clause  (Vik Fearing <vik@postgresfriends.org>)
Responses Re: Proposal: QUALIFY clause
List pgsql-hackers
On 2025-07-22 Tu 11:14 AM, Vik Fearing wrote:
>
>
>> I agree that its own clause is best; I just greatly dislike QUALIFY.
>
>
> Sorry.
>

If we were making up our own syntax this would be a sensible thing to 
debate. If we're talking about implementing something we expect to be in 
the standard, I think we will have to live with what the standards 
committee decides, regardless of our preference. We've almost certainly 
been preempted here by other RDBMSs using QUALIFY, heedless of English 
grammar.


cheers


andrew


--
Andrew Dunstan
EDB: https://www.enterprisedb.com




pgsql-hackers by date:

Previous
From: Vik Fearing
Date:
Subject: Re: Proposal: QUALIFY clause
Next
From: Arseniy Mukhin
Date:
Subject: Re: amcheck support for BRIN indexes