Re: [Exim] SQL and aliases.

Top Page
Delete this message
Reply to this message
Author: Steve Haslam
Date:  
To: exim-users
Subject: Re: [Exim] SQL and aliases.
On Mon, Oct 21, 2002 at 11:26:41AM -0500, Eric Renfro wrote:
> On Monday 21 October 2002 11:04 am, Steve Haslam wrote:
> > On Mon, Oct 21, 2002 at 10:59:22AM -0500, Eric Renfro wrote:
> > > Now, I guess, How could I get it to only check domains listed by a
> > > staticlists quqery, and only lookup queries for the desintation being
> > > $local_part, so it doesn't try to double-send emails, and failing the
> > > second time around?
> >
> > sth like:
> >
> > domains = pgsql;SELECT DISTINCT domain FROM staticlists
>
> How about something like this, would come to play:
>
> domainlist staticlists_domains = \
>         ${lookup pgsql {SELECT DISTINCT domain FROM staticlists WHERE domain =
> ${quote_pgsq:$domain}}

>
> How would I use that in the sql_aliases router that's like:
>
> sql_aliases:
> driver = redirect
> # domains = staticlists_domains


domains = +staticlists_domains

SRH
--
Steve Haslam      Reading, UK                           araqnid@???
Debian GNU/Linux Maintainer                               araqnid@???
almost called it today, turned to face the void, numb with the suffering
and the question- "Why am I?"                                  [queensrÿche]