years.sql

CREATE TABLE years (
    id uuid PRIMARY KEY,

    start_date date NOT NULL,
    end_date date NOT NULL,

    CHECK (start_date < end_date),
    CONSTRAINT overlapping_dates EXCLUDE USING GIST (
        box(
            point(date_part('epoch', start_date), date_part('epoch', start_date)),
            point(date_part('epoch', end_date), date_part('epoch', end_date))
        ) WITH &&
    )
);