| 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:
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 |
| 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 |