On May 18, 2012, at 17:06, Jon Smark <jon.smark@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
befiltering one.
>
>
> Thanks for the reply. The number of widgets is variable, but should not be higher than about 20 in the worst case,
with10 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
bestin theory.
David J.