Re: plpgsql default arguments - Mailing list pgsql-general

> I am running postgres on a Linux system and have been using plpgsql to
> write functions.  Is there a way to specify default arguments?

Hello,

there is no possibility define default arguments. But you can write
functions with different count of arguments.

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;

Regards
Pavel Stehule