Arrays in PL/pgSQL routines?
От | Ken Winter |
---|---|
Тема | Arrays in PL/pgSQL routines? |
Дата | |
Msg-id | 005101c60c9f$cfb5f660$6603a8c0@kenxp обсуждение исходный текст |
Ответы |
Re: Arrays in PL/pgSQL routines?
Re: Arrays in PL/pgSQL routines? |
Список | pgsql-sql |
<div class="Section1"><p class="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt; font-family:Verdana">Can arrays be declared in PL/pgSQL routines? If so, how?</span></font><p class="MsoNormal"><font face="Verdana"size="2"><span style="font-size:10.0pt; font-family:Verdana"> </span></font><p class="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt; font-family:Verdana">Section 8.10 of the documentation (<a href="http://www.postgresql.org/docs/7.4/static/arrays.html">http://www.postgresql.org/docs/7.4/static/arrays.html</a>) tellshow to declare and use arrays as table columns. But I don’t find any part of the documentation that says how to declarea simple array local to a PL/pgSQL function. I tried the following guess, but it only won me a “syntax error at ornear VARCHAR:</span></font><p class="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt; font-family:Verdana"> </span></font><p class="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt; font-family:Verdana">DECLARE</span></font><p class="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt; font-family:Verdana"> my_array VARCHAR [];</span></font><p class="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt; font-family:Verdana"> …</span></font><p class="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt; font-family:Verdana"> </span></font><p class="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt; font-family:Verdana">~ TIA</span></font><p class="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt; font-family:Verdana">~ Ken</span></font></div>
В списке pgsql-sql по дате отправления: