On May 18, 2012, at 17:06, Jon Smark <jon.sm...@yahoo.com> 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
