From: | Andrey Vinogradov <octonog(at)gmail(dot)com> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | default parameters |
Date: | 2012-07-02 11:04:31 |
Message-ID: | CAJb-vw+62RmbT0X4fmXnt_yQm_==cv9XAbyiOoDSX8_tfz7ebQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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
--
Thanks and best wishes,
Andrei Vinogradov
email: octonog(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2012-07-02 20:44:29 | Re: Prevent loss of query text when pgAdmin crashes or freezes |
Previous Message | Evan Martin | 2012-07-02 02:32:40 | Prevent loss of query text when pgAdmin crashes or freezes |