equal
deleted
inserted
replaced
46 IF NOT FOUND THEN |
46 IF NOT FOUND THEN |
47 -- Loop over the alias addresses for localpart@the_domain |
47 -- Loop over the alias addresses for localpart@the_domain |
48 FOR rec IN |
48 FOR rec IN |
49 SELECT DISTINCT sender, destination |
49 SELECT DISTINCT sender, destination |
50 FROM alias |
50 FROM alias |
51 LEFT JOIN domain_name USING (gid) |
51 WHERE alias.gid = did |
52 WHERE alias.address = localpart |
52 AND alias.address = localpart |
53 LOOP |
53 LOOP |
54 RETURN NEXT rec; |
54 RETURN NEXT rec; |
55 END LOOP; |
55 END LOOP; |
56 END IF; |
56 END IF; |
57 RETURN; |
57 RETURN; |