Re: "Join" on delimeter aggregate query

On Fri, Jun 06, 2003 at 10:03:29 -0700, Michael A Nachbaur <mike@nachbaur.com> wrote:
> 
> Postfix can deliver to multiple targets, if you separate the targets with 
> comas, like so:
> 
> Source             Target
> joe@bob.org   address1@bob.org,address2@bob.org,....
> 
> What I would like to do, is something like the following (I know I'd need to 
> group the query, but you get the idea):
> 
> Select DISTINCT(Source), JOIN(Target, ',') FROM Aliases
> 
> Is there any way this can be done with Postfix?

You could write an aggregate function to concatenate email addresses with
comma separators.