Re: challenging constraint situation - how do I make it real in SQL? - Mailing list pgsql-general

From John D. Burger
Subject Re: challenging constraint situation - how do I make it real in SQL?
Date
Msg-id 15d22de683381aada63e265d4353b313@mitre.org
Whole thread Raw
In response to challenging constraint situation - how do I make it real in SQL?  ("Harald Armin Massa" <haraldarminmassa@gmail.com>)
List pgsql-general
> I have a business rule which gives me rahter big challenges to "melt
> in SQL":
>
> At one "point in time" only one version may be active.

I have no specific solution, but I highly recommend Richard Snodgrass's
book, Developing Time-Oriented Database Applications in SQL, which
discusses this kind of situation, and many other similar ones.  It's
out of print, but available from his homepage as a PDF:

   http://www.cs.arizona.edu/~rts/

- John D. Burger
   MITRE


pgsql-general by date:

Previous
From: Jorge Godoy
Date:
Subject: Re: [SQL] (Ab)Using schemas and inheritance
Next
From: "A. Kretschmer"
Date:
Subject: Re: column order