Re: Issue with GRANT/COMMENT ON FUNCTION with default

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
regprocedurecast?
 
-- 
Jim C. Nasby, Data Architect                       jim@nasby.net
512.569.9461 (cell)                         http://jim.nasby.net