[PATCH] doc: clarify AS requirement when VALUES used in a FROM clause

From: Ian Lawrence Barwick <barwick(at)gmail(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: [PATCH] doc: clarify AS requirement when VALUES used in a FROM clause
Date: 2026-07-24 09:12:42
Message-ID: CAB8KJ=jrvZdNLLhYSiCgbjLTz2LKEjYw+-HVQkaF+kgk61KtHA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi

Per comment here:

https://www.postgresql.org/message-id/178484951486.1225.14869692065642101159%40wrigleys.postgresql.org

the VALUES documentation [*] still claims an AS clause is required
when VALUES is
used in a FROM clause. This has not been the case since PostgreSQL 16
(commit bcedd8f).

[*] https://www.postgresql.org/docs/current/sql-values.html

Attached patch reworks the offending sentence from:

> Note that an AS clause is required when VALUES is used in a FROM clause, just
> as is true for SELECT. It is not required that the AS clause specify names for
> all the columns, but it's good practice to do so.

to:

> If VALUES is used in a FROM clause, it's not necessary to have an AS clause
> specifying names for each column, but it's good practice to do so.

Regards

Ian Barwick

Attachment Content-Type Size
v1-0001-doc-clarify-AS-requirement-when-VALUES-used-in-a-.patch text/x-patch 1.8 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Laurenz Albe 2026-07-24 09:51:33 Re: [PATCH] doc: clarify AS requirement when VALUES used in a FROM clause
Previous Message Fujii Masao 2026-07-24 08:53:16 Re: Fix publisher-side sequence permission reporting