git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit

Make subquery aliases optional in the FROM clause.

author Dean Rasheed <dean.a.rasheed@gmail.com>

2022年7月20日 08:29:42 +0000 (09:29 +0100)

committer Dean Rasheed <dean.a.rasheed@gmail.com>

2022年7月20日 08:29:42 +0000 (09:29 +0100)

commit bcedd8f5fce0b69970cf0cee7bca560833d05869

tree c37888d24735977b7a0463b0277c1cbe459ac69f tree

parent 1caf915ff31e91031f0a0b8e1016df2b59d6f9de commit | diff

Make subquery aliases optional in the FROM clause.

This allows aliases for sub-SELECTs and VALUES clauses in the FROM
clause to be omitted.

This is an extension of the SQL standard, supported by some other
database systems, and so eases the transition from such systems, as
well as removing the minor inconvenience caused by requiring these
aliases.

Patch by me, reviewed by Tom Lane.

Discussion: https://postgr.es/m/CAEZATCUCGCf82=hxd9N5n6xGHPyYpQnxW8HneeH+uP7yNALkWA@mail.gmail.com

doc/src/sgml/ref/select.sgml diff | blob | blame | history

src/backend/parser/analyze.c diff | blob | blame | history

src/backend/parser/gram.y diff | blob | blame | history

src/backend/parser/parse_clause.c diff | blob | blame | history

src/backend/parser/parse_relation.c diff | blob | blame | history

src/backend/utils/adt/ruleutils.c diff | blob | blame | history

src/include/parser/parse_node.h diff | blob | blame | history

src/interfaces/ecpg/preproc/ecpg.addons diff | blob | blame | history

src/test/regress/expected/subselect.out diff | blob | blame | history

src/test/regress/sql/subselect.sql diff | blob | blame | history

This is the main PostgreSQL git repository.

RSS Atom