agora inbox for pgsql-committers@postgresql.org
help / color / mirror / Atom feedFrom: Fujii Masao <fujii@postgresql.org>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: doc: clarify aliasing of VALUES in FROM clauses
Date: Tue, 01 Sep 2026 13:53:00 +0000
Message-ID: <E1x1Ov5-000000032pg-3FWo@gemulon.postgresql.org> (raw)
doc: clarify aliasing of VALUES in FROM clauses
The VALUES reference page said that an AS clause was required when
VALUES is used in a FROM clause. This was imprecise because AS is
optional when specifying an alias.
In v14 and v15, a table alias is still required in this case, so state
that explicitly instead. In v16 and later, commit bcedd8f5fce made table
aliases for subqueries in FROM clauses optional, so state that the
table alias is optional there. In all branches, continue to recommend
explicit column aliases as good practice.
Backpatch to all supported versions.
Author: Ian Barwick <barwick@gmail.com>
Reviewed-by: Laurenz Albe <laurenz.albe@cybertec.at>
Reviewed-by: Fujii Masao <masao.fujii@gmail.com>
Discussion: https://postgr.es/m/CAB8KJ=jrvZdNLLhYSiCgbjLTz2LKEjYw+-HVQkaF+kgk61KtHA@mail.gmail.com
Backpatch-through: 14
Branch
------
REL_17_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/45dc7bd2492a05a737f75dae4f5667142a5b562a
Modified Files
--------------
doc/src/sgml/ref/values.sgml | 7 +++----
1 file changed, 3 insertions(+), 4 deletions(-)
view thread (7+ messages) latest in thread
Message-ID: <E1x1Ov5-000000032pg-3FWo@gemulon.postgresql.org>
Permalink: ../E1x1Ov5-000000032pg-3FWo@gemulon.postgresql.org/
Also on: postgresql.org/message-id/E1x1Ov5-000000032pg-3FWo@gemulon.postgresql.org
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: pgsql-committers@postgresql.org
Cc: fujii@postgresql.org, pgsql-committers@lists.postgresql.org
Subject: Re: pgsql: doc: clarify aliasing of VALUES in FROM clauses
In-Reply-To: <E1x1Ov5-000000032pg-3FWo@gemulon.postgresql.org>
* 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