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
On Wed, Oct 12, 2011 at 11:23 PM, Simon Riggs <simon@xxxxxxxxxxxxxxx> wrote:
There's nothing in constraint exclusion that depends upon specific datatypes.On Wed, Oct 12, 2011 at 10:16 AM, Julien Rouhaud <rjuju123@xxxxxxxxx> wrote:
> Hi everyone,
> Is there an easy way (that I maybe missed) to use constraint exclusion with
> 2 floats ?
> Must I find an extension the temporal extension which create a new type with
> 2 timestamp or can I usethe && operator with 2 fields ?
Let us know if you find a problem with floats.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
