equal
deleted
inserted
replaced
473 AS $$ |
473 AS $$ |
474 DECLARE |
474 DECLARE |
475 record recipient_transport; |
475 record recipient_transport; |
476 recipient varchar(320) := localpart || '@' || the_domain; |
476 recipient varchar(320) := localpart || '@' || the_domain; |
477 did bigint := (SELECT gid FROM domain_name WHERE domainname = the_domain); |
477 did bigint := (SELECT gid FROM domain_name WHERE domainname = the_domain); |
478 transport_id bigint := (SELECT tid FROM users |
478 transport_id bigint; |
479 WHERE gid = did AND local_part = localpart); |
479 BEGIN |
480 BEGIN |
480 IF did IS NULL THEN |
|
481 RETURN; |
|
482 END IF; |
|
483 |
|
484 SELECT tid INTO transport_id |
|
485 FROM users |
|
486 WHERE gid = did AND local_part = localpart; |
|
487 |
481 IF transport_id IS NULL THEN |
488 IF transport_id IS NULL THEN |
482 SELECT tid INTO STRICT transport_id |
489 SELECT tid INTO STRICT transport_id |
483 FROM domain_data |
490 FROM domain_data |
484 WHERE gid = did; |
491 WHERE gid = did; |
485 END IF; |
492 END IF; |