Re: Interval referential integrity

From: "Jim C(dot) Nasby" <jim(at)nasby(dot)net>
To: Rodrigo Sakai <rodrigo(dot)sakai(at)zanthus(dot)com(dot)br>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Interval referential integrity
Date: 2006-10-19 15:46:19
Message-ID: 20061019154618.GW71084@nasby.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jim C. Nasby 2006-10-19 15:50:08 Re: timestamp as primary key?
Previous Message James Cradock 2006-10-19 15:35:44 Re: PostGIS