Re: Error in exclusion constraint error message (8.5)?

On Sat, Jan 2, 2010 at 1:37 PM, hubert depesz lubaczewski
<depesz(at)depesz(dot)com> wrote:
>    CONSTRAINT overlapping_times EXCLUDE USING GIST (
>        box(
>            point( extract(epoch FROM from_ts at time zone 'UTC'), extract(epoch FROM from_ts at time zone 'UTC') ),
>            point( extract(epoch FROM to_ts at time zone 'UTC')  , extract(epoch FROM to_ts at time zone 'UTC') )
>        ) WITH &&
>

Hm, this would be easier to write as:

CONSTRAINT overlapping_times EXCLUDE USING GIST (
tinterval(from_ts::abstime, to_ts::abstime) WITH &&

But that still seems a bit more complex than ideal. Would it be
reasonable to have a tinterval() constructor which takes timestamptz
data types? Then you could just write

CONSTRAINT overlapping_times
EXCLUDE USING GIST (tinterval(from_ts, to_ts)) USING &&

--
greg