Stephen,
> If you want to return a single row for each user, regardless of the number
> of email addresses, you might use ARRAY() with a subquery, eg (haven't
> tested this to make sure it completely works):
Your query worked perfectly!
> Of course, this will return the addresses as a character varying[], with
> output like {u...@domain.tld,u...@domain.tld}, and would require some minor
> contortions to present it to users cleanly. The array_to_string function may
> help you make it easier to display the results.
Absolutely -- and thank you for the suggestion. I'll be retrieving
the results of the query through PHP, so cleanup in the query may even
be a performance degradation.
> Hope this helps,
You and Rob Sargent have helped a great deal. Thanks to both of you.
-- Gary Chambers
/* Nothing fancy and nothing Microsoft! */
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
