Horton

Allow referring to functions without arguments when unique

Peter Eisentraut <peter_e@gmx.net>

View on postgr.es
Commit: aefeb68741fb9456f14b4d690b0c646e532fea6b
Author: Peter Eisentraut <peter_e@gmx.net>
Date: 2017-03-15T03:55:19Z
Releases: 10.0 
Allow referring to functions without arguments when unique

In DDL commands referring to an existing function, allow omitting the
argument list if the function name is unique in its schema, per SQL
standard.

This uses the same logic that the regproc type uses for finding
functions by name only.

Reviewed-by: Michael Paquier <michael.paquier@gmail.com>

Files

PathChange+/−
doc/src/sgml/ref/alter_extension.sgml modified +1 −1
doc/src/sgml/ref/alter_function.sgml modified +7 −6
doc/src/sgml/ref/alter_opfamily.sgml modified +4 −3
doc/src/sgml/ref/comment.sgml modified +1 −1
doc/src/sgml/ref/create_cast.sgml modified +4 −2
doc/src/sgml/ref/create_transform.sgml modified +8 −4
doc/src/sgml/ref/drop_function.sgml modified +31 −4
doc/src/sgml/ref/grant.sgml modified +1 −1
doc/src/sgml/ref/revoke.sgml modified +1 −1
doc/src/sgml/ref/security_label.sgml modified +1 −1
src/backend/nodes/copyfuncs.c modified +1 −0
src/backend/nodes/equalfuncs.c modified +1 −0
src/backend/parser/gram.y modified +27 −0
src/backend/parser/parse_func.c modified +34 −3
src/include/nodes/parsenodes.h modified +3 −0
src/test/regress/expected/create_function_3.out modified +10 −1
src/test/regress/sql/create_function_3.sql modified +8 −0

Documentation touched