Re: default parameters

On Mon, 2012-07-02 at 15:04 +0400, Andrey Vinogradov wrote:
> Hi,
>
> There is a function with the default parameter:
>
> CREATE OR REPLACE FUNCTION test(p_int integer *default 1*)
> RETURNS void AS
> $BODY$declare
> begin
> --foo;
> end;$BODY$
> LANGUAGE plpgsql VOLATILE
> COST 100;
>
>
> The object browser of the pgAdmin III has been refreshed more than once.
> The SQL query of the test fuction is
>
> CREATE OR REPLACE FUNCTION test(p_int integer) -- <=== default value is
> disappear
> RETURNS void AS
> $BODY$declare
> begin
> --foo;
> end;$BODY$
> LANGUAGE plpgsql VOLATILE
> COST 100;
>
> pgAdmin III Version 1.14.3 (Jun 1 2012, rev:REL-1_14_3)
> postgresql-9.1.4-1-windows-x64
> Windows 7

It works in 1.16 beta 2. And there shouldn't be any more release of
1.14. So I advise you to update to 1.16 beta.

--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com