On Tue, Oct 26, 2004 at 09:49:43 -0400,
Sean Davis <sdavis2@mail.nih.gov> wrote:
>
> Thanks for the reply. The reason all of this comes up is that I have
> an application in which the user can create "sets" of IDs. I then want
> to be able to do logical operations on the sets of IDs and then return
> the database objects based on the ID's in those sets. I tried the
> function version using "ANY" and the simple query using "IN" and found
> an order of magnitude difference in speed (IN is faster). So, it
> appears that using views and where clauses is the way to go here. One
> last question--is there a limit to the length of a SQL query (in terms
> of characters), as some of these sets could be very large (up to 40000
> integers)?
For this kind of task you probably don't want to use arrays. There should
be a table matching sets to the ids that are in them. Then you would be able
to get the information you want using normal queries.