[EMAIL PROTECTED] (James Robinson) writes:
> Academic question here:
>
> Given a table with a pair of any sort of line-segment-esqe
> range delimiter columns, is it possible to build a unique index to
> enforce non-overlapping ranges? Such as:
>
> create table test
> (
>
James Robinson <[EMAIL PROTECTED]> writes:
> Given a table with a pair of any sort of line-segment-esqe range
> delimiter columns, is it possible to build a unique index to enforce
> non-overlapping ranges?
Nope, sorry. Unique indexes enforce non-equality, but there's no way
to pretend
Academic question here:
Given a table with a pair of any sort of line-segment-esqe range
delimiter columns, is it possible to build a unique index to enforce
non-overlapping ranges? Such as:
create table test
(
id int not null primary key,
lo
