Prior to default parameters on functions, GRANT and COMMENT accepted full parameter syntax. IE:
GRANT EXECUTE ON test(t text) TO public
as opposed to regprocedure, which only accepts the data types ( test(text), not test(t text) ).
They do not accept DEFAULT though:
GRANT EXECUTE ON FUNCTION test(t text DEFAULT '') to public;
ERROR: syntax error at or near "DEFAULT"
LINE 1: GRANT EXECUTE ON FUNCTION test(t text DEFAULT '') to public;
Presumably this is just an oversight? Related to that, is it intentional that the regprocedure cast disallows *any*
decoratorsto the function, other than type? If regprocedure at least accepted the full function parameter definition
youcould use it to get a definitive reference to a function.
--
Jim C. Nasby, Data Architect jim@nasby.net
512.569.9461 (cell) http://jim.nasby.net