Re: plpgsql default arguments

Pavel Stehule wrote:
> CREATE OR REPLACE FUNCTION foo(integer, integer) RETURNS integer AS $$
> BEGIN
>   RETURN $1 + $2;
> END; $$ LANGUAGE plpgsql;
>
> CREATE OR REPLACE FUNCTION foo(integer) RETURNS integer AS $$
> BEGIN
>   RETURN foo($1,10); -- 10 is "default" value
> END; $$ LANGUAGE plpgsql;

Note that if you define the "short cut function" in SQL (the second one
above that supplies the default argument), you can take advantage of
function inlining. Granted, it's probably not a huge win, but if all the
function does is return the result of evaluating another function, it
need not be pl/pgsql anyway.

-Neil