"Join" on delimeter aggregate query
От
Michael A Nachbaur
Тема
"Join" on delimeter aggregate query
Дата
Msg-id
200306061003.29430.mike@nachbaur.com
Список
Дерево обсуждения
"Join" on delimeter aggregate query Michael A Nachbaur <mike@nachbaur.com>
Re: "Join" on delimeter aggregate query Bruno Wolff III <bruno@wolff.to>
Re: "Join" on delimeter aggregate query Joe Conway <mail@joeconway.com>
Re: "Join" on delimeter aggregate query Eivind Kvedalen <eivindkv@ifi.uio.no>
Re: "Join" on delimeter aggregate query Michael A Nachbaur <mike@nachbaur.com>
Re: "Join" on delimeter aggregate query Tom Lane <tgl@sss.pgh.pa.us>
Re: "Join" on delimeter aggregate query Eivind Kvedalen <eivindkv@ifi.uio.no>
Re: "Join" on delimeter aggregate query Tom Lane <tgl@sss.pgh.pa.us>
Re: "Join" on delimeter aggregate query Bruno Wolff III <bruno@wolff.to>
Hello everyone, I've set up PostgreSQL as the authentication / configuration database for my mail server (Postfix + Courier-IMAP), and though it works beautifully, I need some help on my aliases query. You see, define aliases in a database table as rows in a column in the form of "Source" and "Target". The problem is that one source address can be delivered to multiple targets (e.g. internal mailing list, or a temporary forward to another address), but postfix only processes the first record returned from an SQL query. 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? -- Michael A Nachbaur
В списке pgsql-sql по дате отправления