I cant create excluding constaint

From: pasman pasmański <pasman(dot)p(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: I cant create excluding constaint
Date: 2012-01-24 11:41:28
Message-ID: CAOWY8=Y=f7voUuJXKhiaRSdhC6ATSmJhVQGqhmDoC-CECRQUeg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sim Zacks 2012-01-24 14:28:54 left join with OR optimization
Previous Message panam 2012-01-24 11:23:01 Re: Best way to create unique primary keys across schemas?