|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
Re: Semi-OT: SQL Aliases to multiple addresses
From: Michael (michaeln
twentyten.org)
Date: Wed Jun 01 2005 - 19:40:15 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
On Wed Jun 01 17:28:18 PDT 2005, Charlie Watts
> On Wed, 1 Jun 2005, Michael Nguyen wrote:
[snip]
>> Does this seem reasonable or would you do it another way?
>
> Firstly, that will include a spurious comma even when forwarders
> is empty. I'm not sure if Postfix minds this or not. A more
> complicated mysql query could solve this easily enough.
Yeah, I hadn't thought about that. I just tried it and Postfix
doesn't care, but I should fix that for the sake of cleanliness.
> But what about the customer, tomorrow, that wants to forward to
> another account, and doesn't want mail delivered locally at all?
You know, this is a great point. Actually, one of the support
guys just mentioned to me that customers have asked for that. I
suppose I could write the SQL query so that there's a "CASE"
clause where I look for a column value (deliver_local = 1). So in
that case, any other ideas on a better way to do this?
Michael
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]