Postgres Pro
Downloads
Home   >   mailing lists

I cant create excluding constaint - Mailing list pgsql-general

From pasman pasmański
Subject I cant create excluding constaint
Date
Msg-id CAOWY8=Y=f7voUuJXKhiaRSdhC6ATSmJhVQGqhmDoC-CECRQUeg@mail.gmail.com
Whole thread Raw
Responses Re: I cant create excluding constaint  (Andreas Kretschmer <akretschmer@spamfence.net>)
Re: I cant create excluding constaint  (hubert depesz lubaczewski <depesz@depesz.com>)
List pgsql-general
Tree view 
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" ?


------------
pasman

pgsql-general by date:

Previous
From: panam
Date:
Subject: Re: Best way to create unique primary keys across schemas?
Next
From: Sim Zacks
Date:
Subject: left join with OR optimization