Обсуждение: How to use Integer array in where IN clause parameter

Hello,
         Can anybody suggest me how to use Integer array inside a function in where IN clause.
In my function, I have used it like
WHERE   d_base.id in (array_to_string (integer_array, ','))

However it does not work. ANy suggestion?

On Thu, 2007-08-16 at 14:36 -0400, Ranjan Kumar Baisak wrote:
> Hello,
>          Can anybody suggest me how to use Integer array inside a
> function in where IN clause.
> In my function, I have used it like
> WHERE   d_base.id in (array_to_string (integer_array, ','))
>
> However it does not work. ANy suggestion?

It looks like you want to use:

WHERE d_base.id = ANY(integer_array)

Regards,
    Jeff Davis