| From: | Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | select by groups |
| Date: | 2004-03-01 22:20:20 |
| Message-ID: | 200403011920.20505.martin@bugs.unl.edu.ar |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
I have a table with names of people, email address, etc, and an identifier
that tells me which group they are in (could be a 1, 2, or 3 person group).
Is it posible to make a query that would give me the name of the persons of
each group in one row? Or do I have to do PL?
--
19:15:01 up 97 days, 1:24, 4 users, load average: 0.00, 0.07, 0.17
-----------------------------------------------------------------
Martín Marqués | select 'mmarques' || '@' || 'unl.edu.ar'
Centro de Telematica | DBA, Programador, Administrador
Universidad Nacional
del Litoral
-----------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Manuel Sugawara | 2004-03-01 22:32:50 | Re: select by groups |
| Previous Message | Michael Chaney | 2004-03-01 21:18:43 | Re: User defined types -- Social Security number... |