variable-count stored proc arguements? - Mailing list pgsql-general

From Ben
Subject variable-count stored proc arguements?
Date
Msg-id 1048966995.21514.7650.camel@purple
Whole thread Raw
Responses Re: variable-count stored proc arguements?  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: "Daniel R. Anderson"
Date:
Subject: Re: Database files - personal curiosity
Next
From: Stephan Szabo
Date:
Subject: Re: Recursive Stored Procs?