Re: [SQL] Question about arrays - Mailing list pgsql-sql

From David Ouellet
Subject Re: [SQL] Question about arrays
Date
Msg-id 37B04237.B949D277@drev.dnd.ca
Whole thread Raw
In response to Question about arrays  (David Ouellet <David.Ouellet@drev.dnd.ca>)
List pgsql-sql
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



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: [SQL] Postres falls down on "having"
Next
From: "Jackson, DeJuan"
Date:
Subject: RE: [SQL] Question about arrays