我试图创建一个触发器，其中插入列中的某些值，如果一个值“currentAttemptCount”变得等于或大于另一个表中的另一个“currentCountLimit”
我有两张table。

@Table(name = "course_items")
public class CourseItem {
    @Id
    @Column(name = "course_item_id")
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Integer id;
    @Column(name = "attempt_count_limit")
    private Integer attemptCountLimit;

@Table(name = "work_course_items")
public abstract class WorkCourseItem {
    @Id
    @Column(name = "work_course_item_id")
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    protected Integer id;
    @Enumerated(EnumType.STRING)
    protected CourseItemState state;
    @ManyToOne
    @JoinColumn(name = "course_item_id", referencedColumnName = "course_item_id")
    protected CourseItem courseItem;
    @Column(name = "current_attempt_count")
    protected Integer currentAttemptCount;

我应该如何比较这些价值呢？尝试类似next的东西，因为在触发器中似乎不需要INNER JOIN

IF ((SELECT attempt_count_limit
         FROM "ts".course_items
         WHERE course_items.course_item_id = new.course_item_id) <=
        (SELECT current_attempt_count
         FROM "ts".work_course_items
         WHERE work_course_items.work_course_item_id = new.work_course_id))
    THEN
      UPDATE "ts".work_course_items
      SET state = 'YEAP_IT_IS'
      WHERE work_course_item_id = new.work_course_item_id;

    END IF;
    RETURN new;
END;
$$ LANGUAGE PLPGSQL;

CREATE OR REPLACE TRIGGER quiz_attempt_count
   BEFORE UPDATE OF state
   ON "ts".work_course_items
   FOR EACH ROW
EXECUTE PROCEDURE change_work_course_state();