On 5/6/14, 1:57 PM, Peter Eisentraut wrote:
On 5/5/14, 4:09 PM, Jim Nasby wrote:
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?
It appears to be specified that way in SQL. The DEFAULT clause is not
part of the function signature.
As in per-ANSI?
Let me ask a related question: is there any reason why we don't accept argument
names or the default specifier in the regprocedure cast?
--
Jim C. Nasby, Data Architect j...@nasby.net
512.569.9461 (cell) http://jim.nasby.net
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
