branch | v0.6.x |
changeset 437 | 9823548b2717 |
parent 382 | 5e6bcb2e010e |
child 485 | 10e9b4855173 |
--- a/pgsql/create_optional_types_and_functions-dovecot-1.2.x.pgsql Wed Oct 26 23:32:58 2011 +0000 +++ b/pgsql/create_optional_types_and_functions-dovecot-1.2.x.pgsql Fri Oct 28 15:51:31 2011 +0000 @@ -410,11 +410,12 @@ BEGIN FOR record IN SELECT userid, passwd, smtp, pop3, imap, sieve - FROM users + FROM users, service_set WHERE gid = (SELECT gid FROM domain_name WHERE domainname = the_domain) AND local_part = localpart + AND service_set.ssid = users.ssid LOOP RETURN NEXT record; END LOOP;