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.