equal
deleted
inserted
replaced
68 record dovecotpassword; |
68 record dovecotpassword; |
69 userid varchar(320) := localpart || '@' || the_domain; |
69 userid varchar(320) := localpart || '@' || the_domain; |
70 BEGIN |
70 BEGIN |
71 FOR record IN |
71 FOR record IN |
72 SELECT userid, passwd, smtp, pop3, imap, sieve |
72 SELECT userid, passwd, smtp, pop3, imap, sieve |
73 FROM users |
73 FROM users, service_set |
74 WHERE gid = (SELECT gid |
74 WHERE gid = (SELECT gid |
75 FROM domain_name |
75 FROM domain_name |
76 WHERE domainname = the_domain) |
76 WHERE domainname = the_domain) |
77 AND local_part = localpart |
77 AND local_part = localpart |
|
78 AND service_set.ssid = users.ssid |
78 LOOP |
79 LOOP |
79 RETURN NEXT record; |
80 RETURN NEXT record; |
80 END LOOP; |
81 END LOOP; |
81 RETURN; |
82 RETURN; |
82 END; |
83 END; |