Horton

Re: Proposal: QUALIFY clause

Marko Tiikkaja <marko@joh.to>

View thread
From: Marko Tiikkaja <marko@joh.to>
To: Thom Brown <thom@linux.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Matheus Alcantara <matheusssilv97@gmail.com>, Isaac Morland <isaac.morland@gmail.com>, Mike Artz <michaeleartz@gmail.com>, Pg Hackers <pgsql-hackers@postgresql.org>, Peter Eisentraut <peter@eisentraut.org>
Date: 2025-07-21T18:38:42Z
Lists: pgsql-hackers 
On Mon, Jul 21, 2025 at 9:32 PM Thom Brown <thom@linux.com> wrote:
>> * I'm not exactly convinced that the committee would standardize
>> it just like this.  For one thing, QUALIFY is not even the right
>> part of speech: it's a verb, and thus more fit to be a primary
>> statement keyword.  What you need here is an adverb (I think ...
>> been a long time since high school English, but my dictionary
>> says WHERE is an adverb).  Maybe they'd be persuaded to do what
>> the existing implementations did, but I wouldn't be at all surprised
>> if they choose a different keyword.
>
>
> I know we're not bikeshedding, but the word REFINE might be more appropriate.

I vote for DONTGIMMEDAT.


.m