Add catch-all possibility

[misc/hallinta-vmail] / postfix.txt

diff --git a/postfix.txt b/postfix.txt
index 8ea1a33..2c9e188 100644 (file)
--- a/postfix.txt
+++ b/postfix.txt
@@ -24,6 +24,15 @@ query = SELECT forward
    JOIN vmail_domain d ON u.vmail_domain_id=d.id
    WHERE u.username || '@' || d.name = '%s' AND forward IS NOT NULL AND forward <> '' AND active = 1
 
+Query mit Catchall mittels u.username = '*'
+
+query = SELECT forward
+   FROM vmail_user u
+   JOIN vmail_domain d ON u.vmail_domain_id=d.id
+   WHERE (u.username || '@' || d.name = '%s' OR u.username || '@' || d.name = '*' || substring('%s' from position('@' in '%s')))
+     AND forward IS NOT NULL AND forward <> '' AND active = 1
+
+
 virtual-mailbox-domains.cf
 
 user = vmail