Received: from bugs.unl.edu.ar (bugs.unl.edu.ar [168.96.132.208]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4IJPXA46983 for ; Fri, 18 May 2001 15:25:34 -0400 (EDT) (envelope-from martin@bugs.unl.edu.ar) Received: by bugs.unl.edu.ar (Postfix, from userid 1004) id 16ABA2AB39; Fri, 18 May 2001 16:26:08 +0300 (GMT) Content-Type: text/plain; charset="iso-8859-1" From: =?iso-8859-1?q?Mart=EDn=20Marqu=E9s?= To: george young , pgsql-sql@postgresql.org Subject: Re: search for groups with a user Date: Fri, 18 May 2001 16:26:07 +0300 X-Mailer: KMail [version 1.2] References: <0105161149400B.29608@bugs> <20010518113549.7efb161a.gry@ll.mit.edu> In-Reply-To: <20010518113549.7efb161a.gry@ll.mit.edu> MIME-Version: 1.0 Message-Id: <01051816260701.00878@bugs> Content-Transfer-Encoding: 8bit X-Archive-Number: 200105/205 X-Sequence-Number: 3022 On Vie 18 May 2001 18:35, george young wrote: > On Wed, 16 May 2001 11:49:40 +0300 > > Martín Marqués wrote: > > I have to search for which groups a certain user is in. I found out that > > the field grolist is of type INT[] (array of integers with reference to > > the uids). To search through the array I need a module which is in > > contrib/array, which I found, but how do I use it? What do I have to do > > to be able to do searches on arrays in the WHERE clause? > > In postgresq-7.0.3, I did: > > cd contrib/array > make > make install This didn't work, but I got it to work, compiling by hand (gcc and ld). Until I found it in the docs.... :-) Saludos... :-) -- Cualquier administra un NT. Ese es el problema, que cualquier administre. ----------------------------------------------------------------- Martin Marques | mmarques@unl.edu.ar Programador, Administrador | Centro de Telematica Universidad Nacional del Litoral -----------------------------------------------------------------