On 10/10/2009 18:52, Pavel Stehule wrote:
> 2009/10/10 Raymond O'Donnell <rod@iol.ie>:
>> My question is, what do people normally do when there's a variable
>> number of parameters? - for example:
>>
>> select ..... where item_id in ( ... );
>>
>
> You can use arrays here.
>
> select ... where item_id = ANY(string_to_array($1, ','))
Nice one! Thanks Pavel.
My item_id values are integers, so I added ::integer[] to the above and
all works nicely:
...where item_id = any(string_to_array($1, ',')::integer[])
Thanks again,
Ray.
------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------