equal
deleted
inserted
replaced
408 record dovecotpassword; |
408 record dovecotpassword; |
409 userid varchar(320) := localpart || '@' || the_domain; |
409 userid varchar(320) := localpart || '@' || the_domain; |
410 BEGIN |
410 BEGIN |
411 FOR record IN |
411 FOR record IN |
412 SELECT userid, passwd, smtp, pop3, imap, sieve |
412 SELECT userid, passwd, smtp, pop3, imap, sieve |
413 FROM users |
413 FROM users, service_set |
414 WHERE gid = (SELECT gid |
414 WHERE gid = (SELECT gid |
415 FROM domain_name |
415 FROM domain_name |
416 WHERE domainname = the_domain) |
416 WHERE domainname = the_domain) |
417 AND local_part = localpart |
417 AND local_part = localpart |
418 LOOP |
418 AND service_set.ssid = users.ssid |
419 RETURN NEXT record; |
419 LOOP |
420 END LOOP; |
420 RETURN NEXT record; |
421 RETURN; |
421 END LOOP; |
422 END; |
422 RETURN; |
423 $$ LANGUAGE plpgsql STABLE |
423 END; |
424 RETURNS NULL ON NULL INPUT |
424 $$ LANGUAGE plpgsql STABLE |
425 EXTERNAL SECURITY INVOKER; |
425 RETURNS NULL ON NULL INPUT |
|
426 EXTERNAL SECURITY INVOKER; |