X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 81829D1DA74 for ; Mon, 1 Mar 2004 22:25:53 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 22089-07 for ; Mon, 1 Mar 2004 18:25:53 -0400 (AST) Received: from bugs.unl.edu.ar (bugs.unl.edu.ar [168.96.132.208]) by svr1.postgresql.org (Postfix) with ESMTP id 6E38DD1D2BA for ; Mon, 1 Mar 2004 18:25:50 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by bugs.unl.edu.ar (Postfix) with ESMTP id 237DE126E3 for ; Mon, 1 Mar 2004 19:20:23 -0300 (ART) Received: from bugs.unl.edu.ar ([127.0.0.1]) by localhost (bugs [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 14239-04 for ; Mon, 1 Mar 2004 19:20:22 -0300 (ART) Received: from localhost (localhost [127.0.0.1]) by bugs.unl.edu.ar (Postfix) with ESMTP id 2E9A3126D5 for ; Mon, 1 Mar 2004 19:20:22 -0300 (ART) From: Martin Marques To: pgsql-sql@postgresql.org Subject: select by groups Date: Mon, 1 Mar 2004 19:20:20 -0300 User-Agent: KMail/1.5.4 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200403011920.20505.martin@bugs.unl.edu.ar> X-Virus-Scanned: by amavisd-new-20030616-p7 (Debian) at unl.edu.ar X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/12 X-Sequence-Number: 17111 I have a table with names of people, email address, etc, and an identifier= =20 that tells me which group they are in (could be a 1, 2, or 3 person group).= =20 Is it posible to make a query that would give me the name of the persons of= =20 each group in one row? Or do I have to do PL? --=20 19:15:01 up 97 days, 1:24, 4 users, load average: 0.00, 0.07, 0.17 ----------------------------------------------------------------- Mart=EDn Marqu=E9s | select 'mmarques' || '@' || 'unl.edu.ar' Centro de Telematica | DBA, Programador, Administrador Universidad Nacional del Litoral -----------------------------------------------------------------