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_14_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/03851df1105da45350e6d8db20d099299b27428c Modified Files -------------- doc/src/sgml/ref/values.sgml | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-)
