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

On Fri, Aug 21, 2026 at 7:06 PM Ian Lawrence Barwick <barwick(at)gmail(dot)com> wrote:
> Revised patch attached.

Thanks for updating the patch!

I was initially thinking this patch should be backpatched to v16, where
commit bcedd8f appeared. However, since an AS clause is optional even
in v14 and v15, while the table alias itself is required there, should
"an AS clause" in the original description be changed to "a table alias"
for v14 and v15 as well?

+ clause, a table alias is optional. Assigning alias names to the columns
+ of the <command>VALUES</command> list is optional, but is good practice.

In queries.sgml, writing a table alias is also described as good
practice according to the SQL standard. So we could mention here that
writing a table alias is good practice as well. But, since this is
already covered in queries.sgml and it seems a bit overkill to repeat
it here, I'm fine with mentioning only assigning alias names to the
columns as good practice.

Thoughts?

Regards,

--
Fujii Masao