Lähettäjä: Peter Galbavy Päiväys: Vastaanottaja: Jason J. Horton Kopio: exim-users Aihe: Re: [Exim] equivilent of lsearch* on mysql/pgsql lookups?
> Maybe I should clarify my question. I use lsearch* so I can have
"catchall" > entries
> in my alias files, like so:
> tom: tommy@???
> jim: james@???
> *: catchall@???
>
> if an email address doesnt match tom, tommy, jim or james, it gets sent to
> the catchall address. Was wondering if there was a way to replicate this with > using pgsql queries. I know I can do something simular to what you have, but > that doesnt allow for a (for lack of a better term) wildcard match.
Ah, missed that. What you then want (I think) is another director, later
that does a select on '*' or whatever you have chosen as a wildcard, and if
it exists in that domain, and you have got that far down the list of
directors, the use that address...