On Thu, 2007-08-16 at 14:36 -0400, Ranjan Kumar Baisak wrote:
> 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)
In response to
pgsql-general by date
|Next:||From: Rainer Bauer||Date: 2007-08-16 19:32:19|
|Subject: Re: Yet Another COUNT(*)...WHERE...question|
|Previous:||From: D. Dante Lorenso||Date: 2007-08-16 18:55:12|
|Subject: Re: SELECT ... FOR UPDATE performance costs? alternatives?|