variable-count stored proc arguements?
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.
Ben <bench@silentmedia.com> writes:
Is there such a thing?
No. If you are working in C, it's possible to make multiple pg_proc
entries pointing to the same C function, but this is a tedious way to
do things; and it doesn't scale to large numbers of arguments.
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.
Perhaps pass the a,b,c values as an array?
regards, tom lane