DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type;
	b=vCaq7ebQlHiEdGW6U/TVgxJamGd7n/vmDY8QhEWjwIPKB78d9rP0RHNkMb/5pzYn8b
	2rexRzgKImdLz4Fbso+zOfm5FdlNuzB4hnZ31ntfoHM8l6sZx274uQYxPCma/aSdVdLv
	IAqYYfCfwkWLSMvoNbCrItzcj6OGu63BQmr7A=
MIME-Version: 1.0
In-Reply-To: <b4651e821002220915w13f81ed4p26fb0a7126ce1fff@mail.gmail.com>
References: <302670f21002211525r65caee9et396c374a3cd64b0d@mail.gmail.com>
	<4B8211B2.6020406@gmail.com>
	<302670f21002220751h6cc363fiad449314d961fcc0@mail.gmail.com>
	<4B82B960.3060901@gmail.com>
	<b4651e821002220915w13f81ed4p26fb0a7126ce1fff@mail.gmail.com>
Date: Mon, 22 Feb 2010 17:43:22 -0500
Message-ID: <302670f21002221443r4ab62e4dk2bc61f4fa55f9a48@mail.gmail.com>
Subject: Re: Join Advice and Assistance
From: Gary Chambers <gwchamb@gmail.com>
To: Stephen Belcher <sycobuny@malkier.net>
Cc: Rob Sargent <robjsargent@gmail.com>, pgsql-sql@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1

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 {user@domain.tld,user@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! */