variable-count stored proc arguements?

Поиск
Список
Период
Сортировка
От Ben
Тема variable-count stored proc arguements?
Дата
Msg-id 1048966995.21514.7650.camel@purple
обсуждение исходный текст
Ответы Re: variable-count stored proc arguements?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Is there such a thing? My guess is there isn't, but I'm trying to figure
out how to encapsulate some "select where foo=a [and foo=b [and foo=c
[...]]]" logic into a stored proc, and that would be an elegant way to
do it.

AFAICT, the next-best alternative is to take a specially-formated text
string as an argument, and then break that up and reassemble it into the
query I want. Not knowing PL/pgSQL very well, I think that implies
writing the function in C, which simply seems overkill for this.


В списке pgsql-general по дате отправления:

Предыдущее
От: "Daniel R. Anderson"
Дата:
Сообщение: Re: Database files - personal curiosity
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Recursive Stored Procs?