How to pass array of values to a stored procedure
От | Curtis Scheer |
---|---|
Тема | How to pass array of values to a stored procedure |
Дата | |
Msg-id | 031936836C46D611BB1B00508BE7345D048DAAB8@gatekeeper.daycos.com обсуждение исходный текст |
Ответы |
Re: How to pass array of values to a stored procedure
Re: How to pass array of values to a stored procedure |
Список | pgsql-sql |
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">Does anyone have any examples of how I would make a stored procedure in plpgsql that would allow for passinga list or arrays of values to be used in an sql </span></font>IN clause? Like so: select * from table where field1in (values).<p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size: 12.0pt"> </span></font><p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size: 12.0pt">Thanks,</span></font><p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size: 12.0pt"> </span></font><p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size: 12.0pt">Curtis</span></font><font face="Arial" size="2"><span style="font-size: 10.0pt;font-family:Arial"></span></font></div>
В списке pgsql-sql по дате отправления: