public inbox for [email protected]
help / color / mirror / Atom feedFrom: David G. Johnston <[email protected]>
To: [email protected]
To: Pg Docs <[email protected]>
Subject: Re: What is a "simple expression"?
Date: Wed, 20 Apr 2022 13:32:36 -0700
Message-ID: <CAKFQuwZtug7OgdhGtOooQxoYbGmaNerFjyWvOSG+=1Pf6G3bog@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
On Wed, Apr 20, 2022 at 12:50 PM PG Doc comments form <
[email protected]> wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/14/sql-select.html
> Description:
>
> Hi there
>
> To start off I'd like to say your documentation is great and very helpful.
> Thanks for that!
>
> https://www.postgresql.org/docs/14/sql-select.html in the section "WINDOW
> clause" talks about "simple expression." I couldn't find any explaining of
> what actually constitutes a simple expression, not by searching for the
> term
> or checking the index.
>
>
Yeah, "simple" there isn't a definitional word, it is there to make the
paragraph, which does qualify what the expression can be, read better.
You should be able to use, unless otherwise noted there or elsewhere, any
of the expression building components listed in the SQL Syntax chapter.
That chapter, for Window Functions, does further note that nesting window
functions isn't possible.
David J.
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]
Subject: Re: What is a "simple expression"?
In-Reply-To: <CAKFQuwZtug7OgdhGtOooQxoYbGmaNerFjyWvOSG+=1Pf6G3bog@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