public inbox for [email protected]
help / color / mirror / Atom feedFrom: David G. Johnston <[email protected]>
To: David Rowley <[email protected]>
Cc: Corey Huinker <[email protected]>
Cc: Greg Stark <[email protected]>
Cc: Andy Fan <[email protected]>
Cc: Zhihong Yu <[email protected]>
Cc: PostgreSQL Developers <[email protected]>
Subject: Re: Window Function "Run Conditions"
Date: Tue, 22 Mar 2022 22:09:27 -0700
Message-ID: <CAKFQuwYwoqT06QGr5kEpCbCfKG9LZ1bDKuuwOVwxrU1aOi4LUA@mail.gmail.com> (raw)
In-Reply-To: <CAApHDvq29swVhJZAgLfVsrXHU-sFbEDePaCzWfauv5UvWu13KA@mail.gmail.com>
References: <CAApHDvqvp3At8++yF8ij06sdcoo1S_b2YoaT9D4Nf+MObzsrLQ@mail.gmail.com>
<CAApHDvrxxkc9dgoRJUHy6U+XmGjSXRF=fQ-_U1-EvzTjCA9XKw@mail.gmail.com>
<CALNJ-vSRgdOsMx-oiOZcMJzcxoRCo0nJr=U8us4eJR8R6n9ZtA@mail.gmail.com>
<CAApHDvpiAUmUMTETAua8XCLFJiFhsZkCwuiW50KDvehexA-SLA@mail.gmail.com>
<CAKU4AWq5MB_inrYUwPQYXU1fCopCwgYK53N2uYGYFBH3QEhZMA@mail.gmail.com>
<CAApHDvp8PSY3GJXNzzrBPJtzRgQ-C85OPy-bypFGmwaT3AjCjQ@mail.gmail.com>
<CAKU4AWrWzXFuGW4d3YTu=TJSWQKTB=J3E8S_5zyuLNR7npomAA@mail.gmail.com>
<CAM-w4HN7D1wgTnKqUEnjie=E_6kJRC08CuGTLQgSirFPo3kY6A@mail.gmail.com>
<CADkLM=eysxtm6fqquPa3fZKQVB_8wvXA_ooPB5iFz4e-0PdV7Q@mail.gmail.com>
<CAApHDvq29swVhJZAgLfVsrXHU-sFbEDePaCzWfauv5UvWu13KA@mail.gmail.com>
On Tue, Mar 22, 2022 at 3:39 PM David Rowley <[email protected]> wrote:
> On Thu, 17 Mar 2022 at 17:04, Corey Huinker <[email protected]>
> wrote:
> > It seems like this effort would aid in implementing what some other
> databases implement via the QUALIFY clause, which is to window functions
> what HAVING is to aggregate functions.
> > example:
> https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax#qualify_clause
>
> Isn't that just syntactic sugar? You could get the same from adding a
> subquery where a WHERE clause to filter rows evaluated after the
> window clause.
>
>
I'd like some of that syntactic sugar please. It goes nicely with my
HAVING syntactic coffee.
David J.
view thread (19+ messages) latest in thread
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], [email protected]
Subject: Re: Window Function "Run Conditions"
In-Reply-To: <CAKFQuwYwoqT06QGr5kEpCbCfKG9LZ1bDKuuwOVwxrU1aOi4LUA@mail.gmail.com>
* 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