Received: from chi-mx.truenorth.com (interlock.truenorth.com [199.221.98.2]) by hub.org (8.9.3/8.9.3) with ESMTP id NAA92532 for ; Tue, 10 Aug 1999 13:05:47 -0400 (EDT) (envelope-from djackson@cpsgroup.com) Received: from cpsmail.cpsgroup.com (cpsmail.cpsgroup.com [144.210.12.10]) by chi-mx.truenorth.com (8.9.3/8.9.3) with ESMTP id MAA47748; Tue, 10 Aug 1999 12:07:37 -0500 (CDT) Received: by cpsmail with Internet Mail Service (5.5.2448.0) id ; Tue, 10 Aug 1999 12:04:59 -0500 Received: by cpsmail with Internet Mail Service (5.5.2448.0) id ; Mon, 9 Aug 1999 15:25:41 -0500 Message-ID: From: "Jackson, DeJuan" To: David Ouellet , pgsql-sql@postgreSQL.org Subject: RE: [SQL] Question about arrays Date: Mon, 9 Aug 1999 15:25:32 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2448.0) Content-Type: text/plain Check contrib/array in the distribution. > -----Original Message----- > From: David Ouellet [SMTP:David.Ouellet@drev.dnd.ca] > Sent: Monday, August 09, 1999 1:19 PM > To: pgsql-sql@postgreSQL.org > Subject: [SQL] 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 > >