On May 18, 2012, at 17:06, Jon Smark <jon.smark@xxxxxxxxx> wrote: > Hi, > >> ...WHERE wid = ANY(string_to_array(?,';')) >> >> where the ? is a parameter that you replace with a semi-colon delimited listing of widget IDs >> >> Performance depends on specifics you have not provided, especially the expected number of widgets you are going to be filtering one. > > > Thanks for the reply. The number of widgets is variable, but should not be higher than about 20 in the worst case, with 10 being > a more average number. Which solution should I opt for in these circumstances? > > Cheers, > Jon > You should just try both and see which one performs better in your specific case. I do not know generally which one is best in theory. David J. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
