From: Bruno Wolff III <bruno@wolff.to>
To: Michael A Nachbaur <mike@nachbaur.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: "Join" on delimeter aggregate query
Date: Sun, 8 Jun 2003 06:37:02 -0500
Message-ID: <20030608113702.GC14337@wolff.to> (raw)
In-Reply-To: <200306061003.29430.mike@nachbaur.com>
References: <200306061003.29430.mike@nachbaur.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: bruno@wolff.to, mike@nachbaur.com
Subject: Re: "Join" on delimeter aggregate query
In-Reply-To: <20030608113702.GC14337@wolff.to>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox