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 по дате отправления:

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: hi let me know the solution to this question
Следующее
От: "Aaron Bono"
Дата:
Сообщение: Re: hi let me know the solution to this question