Advertisement
Guest User

postfix aliases incl. all@ for virtual_alias_maps with MySQL

a guest
Aug 24th, 2015
211
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.24 KB | None | 0 0
  1. -- Careful: untested :)
  2. SELECT GOTO
  3.   FROM alias
  4.  WHERE address='%s'
  5.    AND active = '1'
  6. UNION
  7. SELECT GROUP_CONCAT(CASE WHEN active='1' THEN username ELSE NULL END separator ', ')
  8.   FROM vmail
  9.  WHERE DOMAIN='%d'
  10.    AND '%s'='all@%d';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement