Add REFERENCING tables in trigger about pyrseas HOT 3 CLOSED

CREATE FUNCTION public.test_tr_insert()
    RETURNS trigger
    LANGUAGE 'plpgsql'
AS $BODY$
DECLARE
  qnt int;
BEGIN
	SELECT count(*) INTO qnt FROM inserted;
	RAISE NOTICE 'qnt = %', qnt;
    RETURN NULL;
END;
$BODY$;


CREATE  FUNCTION public.test_tr_delete()
    RETURNS trigger
    LANGUAGE 'plpgsql'
AS $BODY$
DECLARE
  qnt int;
BEGIN
	SELECT count(*) INTO qnt FROM deleted;
	RAISE NOTICE 'qnt = %', qnt;
        RETURN NULL;
END;
$BODY$;


CREATE TABLE test(c1 character varying(20))

CREATE TRIGGER test_tr_insert
    AFTER INSERT
    ON public.test
    REFERENCING NEW TABLE AS inserted
    FOR EACH STATEMENT
    EXECUTE FUNCTION public.test_tr_insert();

CREATE TRIGGER test_tr_delete
    AFTER DELETE
    ON public.test
    REFERENCING OLD TABLE AS deleted
    FOR EACH STATEMENT
    EXECUTE FUNCTION public.test_tr_delete();

    ......
    REFERENCING NEW TABLE AS inserted OLD TABLE AS deleted
    ......

insert into test(c1) VALUES('q'), ('w'), ('e');
result:
NOTICE:  qnt = 3
INSERT 0 3

delete from test where c1 = 'q' OR c1 = 'w'
result:
NOTICE:  qnt = 2
DELETE 2