Hi,<br /><br />There is a function with the default parameter:<br /><br />CREATE OR REPLACE FUNCTION test(p_int integer
<u>default1</u>)<br /> RETURNS void AS<br />$BODY$declare<br />begin<br />--foo;<br />end;$BODY$<br /> LANGUAGE
plpgsqlVOLATILE<br /> COST 100;<br /><br /><br />The object browser of the pgAdmin III has been refreshed more than
once. The SQL query of the test fuction is<br /><br />CREATE OR REPLACE FUNCTION test(p_int integer) -- <=== default
valueis disappear<br /> RETURNS void AS<br />$BODY$declare<br />begin<br />--foo;<br />end;$BODY$<br /> LANGUAGE
plpgsqlVOLATILE<br /> COST 100;<br clear="all" /><br />pgAdmin III Version 1.14.3 (Jun 1 2012, rev:REL-1_14_3)<br
/>postgresql-9.1.4-1-windows-x64<br/> Windows 7<br />-- <br /><pre></pre>Thanks and best wishes,<br
style="color:rgb(51,0,51);font-family:trebuchetms,sans-serif" /><span style="color:rgb(51,0,51);font-family:trebuchet
ms,sans-serif">AndreiVinogradov</span><br style="color:rgb(51,0,51);font-family:trebuchet ms,sans-serif" /><span
style="color:rgb(51,0,51);font-family:trebuchetms,sans-serif"></span><br style="font-family:trebuchet
ms,sans-serif;color:rgb(51,0,51)"/><span style="font-family:trebuchet ms,sans-serif;color:rgb(51,0,51)">email: <a
href="mailto:octonog@gmail.com"target="_blank">octonog@gmail.com</a></span><br /><br />