Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nhH0U-0006UN-Tj for pgsql-docs@arkaria.postgresql.org; Wed, 20 Apr 2022 20:32:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nhH0T-0008TO-Rx for pgsql-docs@arkaria.postgresql.org; Wed, 20 Apr 2022 20:32:57 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nhH0T-0008RA-KM for pgsql-docs@lists.postgresql.org; Wed, 20 Apr 2022 20:32:57 +0000 Received: from mail-ed1-x52e.google.com ([2a00:1450:4864:20::52e]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nhH0R-0003aj-9P for pgsql-docs@lists.postgresql.org; Wed, 20 Apr 2022 20:32:56 +0000 Received: by mail-ed1-x52e.google.com with SMTP id z99so3836984ede.5 for ; Wed, 20 Apr 2022 13:32:55 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=mime-version:references:in-reply-to:from:date:message-id:subject:to; bh=xicVP2QwGvsmHe4avDL97Tfa9IcASAxRTd/yPl/Xsdo=; b=D+19oBegx78LU9hgaI7ru6SMztSizBDo/5cRerrDecyQNzBg8lUHfE4U2zzvS1rPAf hPzghdgc92IsBkeAFsGZMFAhjZ25m4Wwu8EqFj5mKMyBlXOdD1IIM52lEktIqvcmaMne HG6+/HOOMm+KeSkZcYBR+HN4JQx/YZ1J5up2LR6MdE1GE8edb4VlrHKuerwXRgvQkci5 7lCif8fmZV49PUB6YZHK89egb9tjz9NKw45XJV+lCXLgFF+FUPd8xffZpSlkHjUbUsa4 29VhRRToWV3NXC5ABypg39dcLMRb0fOVnAKlnoafj55RohWuE3sROzipae+3k40vqHvg ksPQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to; bh=xicVP2QwGvsmHe4avDL97Tfa9IcASAxRTd/yPl/Xsdo=; b=fcQauPUGTAnfPw0qYS0Wci/OfWi0de3ezMAp57e9K/xcExh5S39dgEzIZ4QC1zFWTk rBB0SBDQjj8s1beQYKjAZGKTXXba+N7yQ27lJA/1wPaMl+u7FEtjZmWGjgNwBYhWPkWu kqpw1P2J36X3hrMG7YG3dfcZLKQifjyB9opF4vZ9zljOekpt5cHh6bg/rzP3oEimKOrX gGkX31KcRwwbOyPGKPjL7D6iZ0VqAMhUPg+frN8OcT6UoLac5RMdTVF4Fp1ufBMJQAgY 34YZiYQ8Ldbnr1N5vRV4IGqwLmipAlA6zp1yJzEUsah9k5E8g7f/F8MX5QVbf5Wb+v0A rZuw== X-Gm-Message-State: AOAM531hv68ol6aO5qzEhagMqNv52cc/nh3LRdSf287htQwR1wTdAtAM QH5FLpiX7H6MRiLYCMkWYu461ubsHKQv2cACknPHSNqn X-Google-Smtp-Source: ABdhPJx6h10ZBIBxPnABB9++1mp0zf5TRTHKuaq1H40tTSSbm8nx/EtygtO7NAjVvEW/DAp94cxdk31DaDfiLy9vSqg= X-Received: by 2002:a05:6402:1941:b0:413:2b5f:9074 with SMTP id f1-20020a056402194100b004132b5f9074mr25140037edz.414.1650486773680; Wed, 20 Apr 2022 13:32:53 -0700 (PDT) MIME-Version: 1.0 References: <165048039069.683.9747915389558753857@wrigleys.postgresql.org> In-Reply-To: <165048039069.683.9747915389558753857@wrigleys.postgresql.org> From: "David G. Johnston" Date: Wed, 20 Apr 2022 13:32:36 -0700 Message-ID: Subject: Re: What is a "simple expression"? To: damian@damianbirchler.net, Pg Docs Content-Type: multipart/alternative; boundary="000000000000da0e9605dd1be523" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000da0e9605dd1be523 Content-Type: text/plain; charset="UTF-8" On Wed, Apr 20, 2022 at 12:50 PM PG Doc comments form < noreply@postgresql.org> 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. --000000000000da0e9605dd1be523 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Wed, Apr 20, 2022 at 12:50 PM PG Doc comments form <= noreply@postgresql.org> wr= ote:
The following documentation comment has been l= ogged on the website:

Page: https://www.postgresql.org/docs/14/sql-selec= t.html
Description:

Hi there

To start off I'd like to say your documentation is great and very helpf= ul.
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 ter= m
or checking the index.


Yeah, "si= mple" there isn't a definitional word, it is there to make the par= agraph, which does qualify what the expression can be, read better.

You should be able to use, unless otherwise noted there or el= sewhere, any of the expression building components listed in the SQL Syntax= chapter.=C2=A0 That chapter, for Window Functions, does further note that = nesting window functions isn't possible.

David J= .
--000000000000da0e9605dd1be523--