Re: I cant create excluding constaint - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject Re: I cant create excluding constaint
Date
Msg-id 20120124144442.GA13570@depesz.com
Whole thread Raw
In response to I cant create excluding constaint  (pasman pasmański <pasman.p@gmail.com>)
List pgsql-general
On Tue, Jan 24, 2012 at 12:41:28PM +0100, pasman pasmański wrote:
> Hi.
>
> I have a table with two columns:
>
> create table "GroupsOfOrders" (
>   "Orders" text[];  -- a set of identifiers
>   "Period" cube; -- a period of time for all identifiers in field "Orders"
> );
>
> How to create excluding constraint, which prevent overlapping "Period"
> for all orders in a field "Orders" ?

http://www.depesz.com/index.php/2010/01/03/waiting-for-8-5-exclusion-constraints/

Best regards,

depesz

--
The best thing about modern society is how easy it is to avoid contact with it.
                                                             http://depesz.com/

pgsql-general by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: I cant create excluding constaint
Next
From: Robert Treat
Date:
Subject: Re: PG 9.0 EBS Snapshot Backups on Slave