<div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida
Grande,sans-serif;font-size:8px"><div id="yui_3_16_0_1_1457446851819_4122">Hello pgAdmin III list,</div><div
id="yui_3_16_0_1_1457446851819_4123"><br/></div><div dir="ltr" id="yui_3_16_0_1_1457446851819_4124">Recently, I found
thatDefault Values of Function Arguments are garbled if they contain unquoted commas. This happens in the Function
PropertyDialog as well as using the CREATE script menu item.</div><div dir="ltr"
id="yui_3_16_0_1_1457446851819_4198"><br/></div><div dir="ltr" id="yui_3_16_0_1_1457446851819_4233">1. Example, where
Defaultis garbled:</div><div dir="ltr" id="yui_3_16_0_1_1457446851819_4337">----</div><div dir="ltr"
id="yui_3_16_0_1_1457446851819_4336">CREATEOR REPLACE FUNCTION blah(foo integer[] DEFAULT ARRAY[1, 2, 3])</div><div
dir="ltr"id="yui_3_16_0_1_1457446851819_4307"> RETURNS integer AS</div><div dir="ltr"
id="yui_3_16_0_1_1457446851819_4234">$BODY$<br />SELECT 1;<br />$BODY$<br /> LANGUAGE sql STABLE;<br />----</div><div
dir="ltr"id="yui_3_16_0_1_1457446851819_4229">#### CREATE script menu item produces:</div><div dir="ltr"
id="yui_3_16_0_1_1457446851819_4265">CREATEOR REPLACE FUNCTION blah(foo integer[] DEFAULT ARRAY[1)<br /> RETURNS
integerAS<br />$BODY$<br />SELECT 1;<br />$BODY$<br /> LANGUAGE sql STABLE<br /> COST 100;</div><div dir="ltr"
id="yui_3_16_0_1_1457446851819_4407"><br/></div><div dir="ltr" id="yui_3_16_0_1_1457446851819_4357">2. Example, where
Defaultis left intact:</div><div dir="ltr" id="yui_3_16_0_1_1457446851819_4356">----</div><div dir="ltr"
id="yui_3_16_0_1_1457446851819_4352">CREATEOR REPLACE FUNCTION blub(bar integer[] DEFAULT '{1,2,3}'::integer[])<br
/> RETURNSinteger AS</div><div dir="ltr" id="yui_3_16_0_1_1457446851819_4383"> $BODY$<br />SELECT 1;<br />$BODY$<br
/> LANGUAGEsql STABLE;<br />----</div><div dir="ltr" id="yui_3_16_0_1_1457446851819_4229">#### CREATE script menu item
produces:</div><divdir="ltr" id="yui_3_16_0_1_1457446851819_4426">CREATE OR REPLACE FUNCTION blub(bar integer[] DEFAULT
'{1,2,3}'::integer[])<br/> RETURNS integer AS<br />$BODY$<br />SELECT 1;<br />$BODY$<br /> LANGUAGE sql STABLE<br />
COST100;</div><div dir="ltr" id="yui_3_16_0_1_1457446851819_4481"><br /></div><div dir="ltr"
id="yui_3_16_0_1_1457446851819_4480">3.Fortunately, the psql command \sf works correctly and reproduces these functions
asshown above in the first place.</div><div dir="ltr" id="yui_3_16_0_1_1457446851819_4479"><br /></div><div dir="ltr"
id="yui_3_16_0_1_1457446851819_4478">Idid my test with the Windows Program pgAdmin Version 1.22.0 (Jan 8 2016,
rev:REL-1_22_0)under Windows 7 64bit.</div><div dir="ltr" id="yui_3_16_0_1_1457446851819_4578"><br /></div><div
dir="ltr"id="yui_3_16_0_1_1457446851819_4577">Please fix this bug.</div><div dir="ltr"
id="yui_3_16_0_1_1457446851819_4673"><br/></div><div dir="ltr" id="yui_3_16_0_1_1457446851819_4674">Happy
computing...</div><divdir="ltr" id="yui_3_16_0_1_1457446851819_4675">Frank<br /></div></div>