用触发器更新SQL记录

BEGIN
    CASE TG_OP
        WHEN ‘UPDATE‘ THEN
            UPDATE
                link
            SET
                priority = priority + 1
            WHERE
                link.priority >= NEW.priority AND
                NOT link.priority >= OLD.priority;
    END CASE;

    RETURN NEW;
END;

用触发器更新SQL记录

标签：cti   return   null   UNC   priority   and   set   code   end