pgsql/create_tables.pgsql
branchv0.6.x
changeset 511 0244f1344b04
parent 503 492c179094c9
child 512 821d3ffaaaca
equal deleted inserted replaced
510:1fa354bbdb90 511:0244f1344b04
   573              WHERE gid = did
   573              WHERE gid = did
   574                AND address = localpart
   574                AND address = localpart
   575             LOOP
   575             LOOP
   576                 RETURN NEXT record;
   576                 RETURN NEXT record;
   577             END LOOP;
   577             END LOOP;
       
   578         IF NOT FOUND THEN
       
   579             FOR record IN
       
   580                 SELECT recipient, destination
       
   581                   FROM catchall
       
   582                  WHERE gid = did
       
   583                 LOOP
       
   584                     RETURN NEXT record;
       
   585                 END LOOP;
       
   586         END IF;
   578         RETURN;
   587         RETURN;
   579     END;
   588     END;
   580 $$ LANGUAGE plpgsql STABLE
   589 $$ LANGUAGE plpgsql STABLE
   581 RETURNS NULL ON NULL INPUT
   590 RETURNS NULL ON NULL INPUT
   582 EXTERNAL SECURITY INVOKER;
   591 EXTERNAL SECURITY INVOKER;