首先,添加btree_gist擴展名。 CREATE EXTENSION btree_gist; 然后使用以下排除創建表。 CREATE TABLE code.visit ( pk_user_id VARCHAR(3), pk_place_id VARCHAR(8), data DATE, CONSTRAINT pk_user_id FOREIGN KEY (pk_user_id) REFERENCES code.user, CONSTRAINT pk_place_id FOREIGN KEY (pk_place_id) REFERENCES code.place, EXCLUDE USING gist (pk_user_id WITH =, pk_place_id WITH =, daterange(data, (data + interval '6 months')::date) WITH &&)); 現在讓我們輸入一些數據。 INSERT INTO code.user VALUES ('ABC', 'Albert Brian Cohen');INSERT INTO code.place VALUES ('MADRID', 'Madrid, Spain');INSERT INTO code.visit VALUES ('ABC', 'MADRID', CURRE