Re: "Join" on delimeter aggregate query

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: "Join" on delimeter aggregate query
Дата
Msg-id 20030608113702.GC14337@wolff.to
обсуждение исходный текст
Ответ на "Join" on delimeter aggregate query  (Michael A Nachbaur <mike@nachbaur.com>)
Список 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 по дате отправления:

Предыдущее
От: Ian Barwick
Дата:
Сообщение: Re: Elegant SQL solution:
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: How to make a IN without a table... ?