diff -r 89b71a9abfcf -r 6c85915f3815 create_optional_types_and_functions.pgsql --- a/create_optional_types_and_functions.pgsql Wed Sep 10 00:00:37 2008 +0000 +++ b/create_optional_types_and_functions.pgsql Thu Sep 11 20:38:30 2008 +0000 @@ -48,8 +48,8 @@ FOR rec IN SELECT DISTINCT sender, destination FROM alias - LEFT JOIN domain_name USING (gid) - WHERE alias.address = localpart + WHERE alias.gid = did + AND alias.address = localpart LOOP RETURN NEXT rec; END LOOP;