SQL Question

From: Fernando Carvalho <f.carvalho_at_mail.telepac.pt>
Date: Fri, 16 Oct 1998 13:03:49 +0100
Message-ID: <707g3u$nig$1@duke.telepac.pt>

With the following table:

create table Tax
(

ID      number not null,
Init     date not null,

Final date not null,
constraint pk+AF8-tax primary key (ID)
)

How to create a constraint (or trigger) that doesn't let to insert overlapping date intervals?

Regards

Fernando Carvalho Received on Fri Oct 16 1998 - 07:03:49 CDT