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 jim(at)nasby(dot)net
512.569.9461 (cell) http://jim.nasby.net