| From: | hubert depesz lubaczewski <depesz(at)depesz(dot)com> |
|---|---|
| To: | pasman pasmański <pasman(dot)p(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: I cant create excluding constaint |
| Date: | 2012-01-24 14:44:42 |
| Message-ID: | 20120124144442.GA13570@depesz.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Treat | 2012-01-24 15:04:37 | Re: PG 9.0 EBS Snapshot Backups on Slave |
| Previous Message | Andreas Kretschmer | 2012-01-24 14:35:33 | Re: I cant create excluding constaint |