CREATE OR REPLACE FUNCTION "public"."INS_INV" (INV public.inv_t, PERS public.person) RETURNS "public"."al_inv_success" AS
$body$
DECLARE
       inv_counter  integer:= nextval('"public"."inverticement_id_seq"'::text);
       pers_counter integer:= nextval('"public"."contact_information_id_seq"'::text);
       alert al_inv_success:=(pers_counter,inv_counter, 0 );
BEGIN
       BEGIN
            INSERT INTO "public"."contact_information" ("id", "fio", "adress", "telnomber", "E-meil", "web", "icq")
            values(pers_counter,PERS.fio,PERS.adress,PERS.telnomber,PERS.E-meil,PERS.web,PERS.icq);

            INSERT INTO "public"."inverticement" ("id", "cat_id", "contact_id", "content_letter", "is_active", "is_acive_picture", "priority", "date_in", "date_out")
            values(inv_counter,INV.cat_id,pers_counter,INV.content_letter, 0 , 0 ,INV.priority,INV.date_in,INV.date_out);
            
       EXCEPTION
        WHEN OTHERS  THEN
            RAISE NOTICE 'caught bad insert';
            RETURN alert;
       END;
alert.success= 1 ;
RETURN alert;
END;
$body$
LANGUAGE 'plpgsql' VOLATILE CALLED ON NULL INPUT SECURITY INVOKER;