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 f4GEnFA14338 for ; Wed, 16 May 2001 10:49:16 -0400 (EDT) (envelope-from martin@bugs.unl.edu.ar) Received: by bugs.unl.edu.ar (Postfix, from userid 1004) id 3CCDC2AB39; Wed, 16 May 2001 11:49:42 +0300 (GMT) Content-Type: text/plain; charset="iso-8859-1" From: =?iso-8859-1?q?Mart=EDn=20Marqu=E9s?= To: pgsql-sql@postgresql.org Subject: search for groups with a user Date: Wed, 16 May 2001 11:49:40 +0300 X-Mailer: KMail [version 1.2] MIME-Version: 1.0 Message-Id: <0105161149400B.29608@bugs> Content-Transfer-Encoding: 8bit X-Archive-Number: 200105/164 X-Sequence-Number: 2981 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? 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 -----------------------------------------------------------------