假设我有一张桌子放松_SCHEDULE，带有一个varteant_id和一个类型的时间表（或其他任何其他范围），
我知道如何使用排除约束来防止直接相邻，例如：
alter table relaxed_schedule
add constraint my_exclude_constraint
exclude using gist ( contestant_id with =, timeslot with -|-);
但是我在寻找的是什么 。因为是一种强制执行杂物相邻的方法，因此相反。是否有接近以下内容？
alter table tight_schedule
add constraint my_exclude_constraint
exclude using gist ( contestant_id with =, timeslot with !-|-);
这是一个示例小提琴：
Let's say I have a table relaxed_schedule, with a contestant_id and a timeslot of type daterange (or any other range, really)
I know how to use an exclude constraint to prevent dateranges from being directly adjacent, like so:
alter table relaxed_schedule
add constraint my_exclude_constraint
exclude using gist ( contestant_id with =, timeslot with -|-);
But what I'm looking for is a way to enforce that the dateranges are adjacent, so quite the opposite. Is there something that comes close to the following?
alter table tight_schedule
add constraint my_exclude_constraint
exclude using gist ( contestant_id with =, timeslot with !-|-);
Here's an example fiddle: https://dbfiddle.uk/?rdbms=postgres_14&fiddle=172bf2ef20b1289318872ee171374abf
发布评论