Re: [exim] Re: Fetch regexp for match from database

Top Page
Delete this message
Reply to this message
Author: Tony Finch
Date:  
To: Thomas Mueller
CC: exim-users
Subject: Re: [exim] Re: Fetch regexp for match from database
On Sat, 11 Jun 2005, Thomas Mueller wrote:
>
> The condition posted above works as expected now, but it doesn't work if
> I add a where clause:
> condition = ${if match{$local_part}{${lookup pgsql{SELECT '([0-9]+)' \
>       WHERE '${quote_pgsql:$domain}' = 'tmueller.com'}}}{yes}{no}}

>
> This matches always, even something like example@???.
> match{$local_part}{} seems to be true?


I guess that'll be because if the WHERE clause is false the result of the
lookup is the empty string, and every string matches the null regex.

Tony.
--
<fanf@???> <dot@???> http://dotat.at/ ${sg{\N${sg{\
N\}{([^N]*)(.)(.)(.*)}{\$1\$3\$2\$1\$3\n\$2\$3\$4\$3\n\$3\$2\$4}}\
\N}{([^N]*)(.)(.)(.*)}{\$1\$3\$2\$1\$3\n\$2\$3\$4\$3\n\$3\$2\$4}}