Re: [SQL] Question about arrays

From: David Ouellet <David(dot)Ouellet(at)drev(dot)dnd(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] Question about arrays
Date: 1999-08-10 15:16:07
Message-ID: 37B04237.B949D277@drev.dnd.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Evan Simpson 1999-08-10 17:19:56 PROPOSAL: Statement for one-sided joins
Previous Message Tom Lane 1999-08-10 14:55:32 Re: [SQL] Postres falls down on "having"