Postgres trigger есть ли поле в запросе

CREATE OR REPLACE FUNCTION completed_upsert_v1() RETURNS TRIGGER AS
$BODY$
BEGIN
    IF (NEW.is_completed IS NOT NULL) THEN
        NEW.completed = NEW.is_completed;
    END IF;

    RETURN NEW;
END ;
$BODY$ LANGUAGE plpgsql;

CREATE TRIGGER completed_trigger
    BEFORE INSERT OR UPDATE ON some_table
    FOR EACH ROW
EXECUTE PROCEDURE completed_upsert_v1();

есть ли возможность понять разницу между

update some_table set is_completed = null where id = 10

или

update some_table set another_field = 'some value' where id = 10

т.е. NEW.is_completed в обоих случаях будет NULL


Ответы (0 шт):