Re: "Join" on delimeter aggregate query

On Fri, Jun 06, 2003 at 10:03:29 -0700,
Michael A Nachbaur <mike(at)nachbaur(dot)com> wrote:
>
> Postfix can deliver to multiple targets, if you separate the targets with
> comas, like so:
>
> Source Target
> joe(at)bob(dot)org address1(at)bob(dot)org,address2(at)bob(dot)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.