Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.

Dismiss

UNIQUE-Constraints for ranges

0 views

Skip to first unread message

unread,

Jul 20, 2008, 4:28:46 PM7/20/08

Hi,

I have a database with a Datetime-column. I'd like to build a constraint
that expresses the following scenario:

I add a dataset on 01/01/2000 00:00. The next dataset must not be added
earlier than 10 days later, so that I can add a new dataset on 01/11/2000.

Is it possible to build constraints that do not make only a single value
unique, but a whole range?

Fabian.

0 new messages