Received: from fw.drenet.dnd.ca (fw.drenet.dnd.ca [131.136.242.1]) by hub.org (8.9.3/8.9.3) with ESMTP id LAA68732 for ; Tue, 10 Aug 1999 11:16:39 -0400 (EDT) (envelope-from David.Ouellet@drev.dnd.ca) Message-ID: <37B04237.B949D277@drev.dnd.ca> Date: Tue, 10 Aug 1999 11:16:07 -0400 From: David Ouellet X-Mailer: Mozilla 4.61 [en] (Win98; I) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Re: [SQL] Question about arrays References: <37AF1B85.B0463BA1@drev.dnd.ca> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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