Re: "Join" on delimeter aggregate query - Mailing list pgsql-sql

From Bruno Wolff III
Subject Re: "Join" on delimeter aggregate query
Date
Msg-id 20030608113702.GC14337@wolff.to
Whole thread Raw
In response to "Join" on delimeter aggregate query  (Michael A Nachbaur <mike@nachbaur.com>)
List pgsql-sql
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.


pgsql-sql by date:

Previous
From: Ian Barwick
Date:
Subject: Re: Elegant SQL solution:
Next
From: Bruno Wolff III
Date:
Subject: Re: How to make a IN without a table... ?