Re: Proposal: QUALIFY clause

From: Marko Tiikkaja <marko(at)joh(dot)to>
To: Thom Brown <thom(at)linux(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Matheus Alcantara <matheusssilv97(at)gmail(dot)com>, Isaac Morland <isaac(dot)morland(at)gmail(dot)com>, Mike Artz <michaeleartz(at)gmail(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>, Peter Eisentraut <peter(at)eisentraut(dot)org>
Subject: Re: Proposal: QUALIFY clause
Date: 2025-07-21 18:38:42
Message-ID: CAL9smLCiv61CLVPFNvw1j1jYB4PLAyawL-OWr71Zt+PRxbLEpw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Jul 21, 2025 at 9:32 PM Thom Brown <thom(at)linux(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Sabino Mullane 2025-07-21 19:06:31 Re: [PATCH] Generate random dates/times in a specified range
Previous Message Andres Freund 2025-07-21 18:35:10 Re: [PATCH] Let's get rid of the freelist and the buffer_strategy_lock