On Wed, Oct 12, 2011 at 10:40 PM, Julien Rouhaud <rjuju123@xxxxxxxxx> wrote: > Thank you for your answer. > > I'm sorry I really didn't explained well my problem :/ > > For example if I have a table test like this : > CREATE TABLE test (min real not null, max real not null, desc character > varying not null); > > and I want a constraint exclusion to make sure the range min/max doens't > overlap > > I can't write ALTER TABLE test add constraint test_exclude EXCLUDE USING > btree ((min,max) WITH &&) > > I saw the extension temporal gives a new type PERIOD and has operators like > &&, but only for timestamp, so I'm wondering if I must code something > something similar or if there's is an easier way You've confused "exclusion constraints" with "constraint exclusion", which does seem easy to do. "Exclusion constraints" are not limited to a single datatype either, so you should be able to find a solution. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
