Re: Using constraint exclusion with 2 floats

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Julien Rouhaud <rjuju123(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Using constraint exclusion with 2 floats
Date: 2011-10-12 21:23:02
Message-ID: CA+U5nML9q-1OLy-0N_m9PRMyLBVUd5ARYup1Gdf60TXYYxG6nQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Oct 12, 2011 at 10:16 AM, Julien Rouhaud <rjuju123(at)gmail(dot)com> 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 ?

There's nothing in constraint exclusion that depends upon specific datatypes.

Let us know if you find a problem with floats.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Simon Riggs 2011-10-12 21:23:05 Re: pg 8.3 replication causing corruption
Previous Message Bob Hatfield 2011-10-12 21:11:26 Re: pg 8.3 replication causing corruption