Re: [GENERAL] Using constraint exclusion with 2 floats

2011-10-17 Thread Simon Riggs
On Wed, Oct 12, 2011 at 10:40 PM, Julien Rouhaud 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

Re: [GENERAL] Using constraint exclusion with 2 floats

2011-10-12 Thread Julien Rouhaud
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 ove

Re: [GENERAL] Using constraint exclusion with 2 floats

2011-10-12 Thread Simon Riggs
On Wed, Oct 12, 2011 at 10:16 AM, Julien Rouhaud 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 ?

[GENERAL] Using constraint exclusion with 2 floats

2011-10-12 Thread Julien Rouhaud
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 ? Thank you