Horton

Allow an alias to be attached to a JOIN ... USING

Peter Eisentraut <peter@eisentraut.org>

View on postgr.es
Commit: 055fee7eb4dcc78e58672aef146334275e1cc40d
Author: Peter Eisentraut <peter@eisentraut.org>
Date: 2021-03-31T15:10:50Z
Releases: 14.0 
Allow an alias to be attached to a JOIN ... USING

This allows something like

    SELECT ... FROM t1 JOIN t2 USING (a, b, c) AS x

where x has the columns a, b, c and unlike a regular alias it does not
hide the range variables of the tables being joined t1 and t2.

Per SQL:2016 feature F404 "Range variable for common column names".

Reviewed-by: Vik Fearing <vik.fearing@2ndquadrant.com>
Reviewed-by: Tom Lane <tgl@sss.pgh.pa.us>
Discussion: https://www.postgresql.org/message-id/flat/454638cf-d563-ab76-a585-2564428062af@2ndquadrant.com

Files

PathChange+/−
doc/src/sgml/ref/select.sgml modified +14 −2
src/backend/catalog/sql_features.txt modified +1 −1
src/backend/nodes/copyfuncs.c modified +2 −0
src/backend/nodes/equalfuncs.c modified +2 −0
src/backend/nodes/outfuncs.c modified +2 −0
src/backend/nodes/readfuncs.c modified +2 −0
src/backend/optimizer/plan/setrefs.c modified +1 −0
src/backend/optimizer/plan/subselect.c modified +2 −0
src/backend/parser/analyze.c modified +1 −0
src/backend/parser/gram.y modified +51 −9
src/backend/parser/parse_clause.c modified +32 −0
src/backend/parser/parse_expr.c modified +50 −15
src/backend/parser/parse_relation.c modified +8 −0
src/backend/utils/adt/ruleutils.c modified +4 −0
src/include/nodes/parsenodes.h modified +7 −0
src/include/nodes/primnodes.h modified +6 −0
src/include/parser/parse_node.h modified +4 −1
src/include/parser/parse_relation.h modified +1 −0
src/test/regress/expected/create_view.out modified +51 −1
src/test/regress/expected/join.out modified +52 −0
src/test/regress/sql/create_view.sql modified +11 −0
src/test/regress/sql/join.sql modified +11 −0

Documentation touched

Discussion