default parameters
| От | Andrey Vinogradov |
|---|---|
| Тема | default parameters |
| Дата | |
| Msg-id | CAJb-vw+62RmbT0X4fmXnt_yQm_==cv9XAbyiOoDSX8_tfz7ebQ@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: default parameters
Re: default parameters |
| Список | pgadmin-support |
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 />
В списке pgadmin-support по дате отправления: