Re: Interval referential integrity - Mailing list pgsql-general

From Jim C. Nasby
Subject Re: Interval referential integrity
Date
Msg-id 20061019154618.GW71084@nasby.net
Whole thread Raw
In response to Interval referential integrity  ("Rodrigo Sakai" <rodrigo.sakai@zanthus.com.br>)
List pgsql-general
On Thu, Oct 19, 2006 at 07:51:17AM -0300, Rodrigo Sakai wrote:
>   I?m developing a specialist application that needs a different kind of
> referential integrity! I need interval referential integrity where the
> bounds of the referenced interval must overlaps (or be equal) the bounds of
> the referencing interval!

Use triggers.
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

pgsql-general by date:

Previous
From: James Cradock
Date:
Subject: Re: PostGIS
Next
From: "Jim C. Nasby"
Date:
Subject: Re: timestamp as primary key?