postfix-users February 2012 archive
| Main Archive Page > Month Archives > postfix-users archives |
Re: check_recipient_access in MySQL
From: Reindl Harald <h.reindl_at_nospam>Date: Wed Feb 15 2012 - 23:16:46 GMT
To: postfix-users@postfix.org
Am 16.02.2012 00:14, schrieb Benny Pedersen:
> Den 2012-02-15 15:50, Jack Knowlton skrev:
>
>> user@domain.com REJECT This particular user has been banned.
>> user1@domain.com REJECT This particular user has been banned.
>
> select concat(´REJECT This user is banned´) from banned_usertable where useremail = ´%s´
>
> test as usual with postmap that it works
´ is wrong for a string, use '
the whole concat is not needed!
select 'REJECT This user is banned' from banned_usertable where useremail = '%s'
will do exactly the same