Thread: Question about arrays

Hi,
Is there an operator to test if a value is contained into an array?

What I'm trying to do is create a function to check is a certain user
belongs to a certain group.
I want to check is the userid is contained in the pg_grouip.grolist
array.

How would I do that?

Thanks in advance
David Ouellet

Never mind, I found the answer.
For those interested, look at contrib/array it adds a whole bunch of
operators that iterates over an array.

David Ouellet

David Ouellet wrote:

> Hi,
> Is there an operator to test if a value is contained into an array?
>
> What I'm trying to do is create a function to check is a certain user
> belongs to a certain group.
> I want to check is the userid is contained in the pg_grouip.grolist
> array.
>
> How would I do that?
>
> Thanks in advance
> David Ouellet