What about local domains?

> $sql_select_policy =
>   'SELECT *, user.id'.
>   ' FROM (SELECT 1 as id, 99 as policy_id, 1 as
priority'.
>   '       FROM domain WHERE CONCAT("",domain_name) IN (%k)'.
>   '       ORDER BY priority DESC) AS user'.
>   ' LEFT JOIN policy ON policy_id=policy.id';

Actually in this last example the sort is redundant,
as all records are of the same type (just a domain name)
and have the same priority, so it boils down to:

$sql_select_policy =
  'SELECT *, user.id'.
  ' FROM (SELECT 1 as id, 99 as policy_id FROM domain'.
  '       WHERE CONCAT("",domain_name) IN
(%k)) AS user'.
  ' LEFT JOIN policy ON policy_id=policy.id';


Mark

------------------------------------------------------------
-------------
Using Tomcat but need to do more? Need to support web
services, security?
Get stuff done quickly with pre-integrated technology to
make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on
Apache Geronimo
http://sel.as-us.falkag.net/
sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
AMaViS-user mailing list
AMaViS-userlists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/amavis-user

AMaViS-FAQ:http://www.amav
is.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/ho
wto/