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