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 <[email protected]> Reviewed-by: Laurenz Albe <[email protected]> Reviewed-by: Fujii Masao <[email protected]> Discussion: https://postgr.es/m/CAB8KJ=jrvzdnllhysicgbjltz2lkejyw+-hvqkaf+kgk61k...@mail.gmail.com Backpatch-through: 14 Branch ------ REL_15_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/b6d2d82871c3dee3508c67a3b17ed4356654c036 Modified Files -------------- doc/src/sgml/ref/values.sgml | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-)
