Re: Why overlaps is not working - Mailing list pgsql-general

From Andrus
Subject Re: Why overlaps is not working
Date
Msg-id 033601c7071e$c1684d40$2300b3a8@Andrus
Whole thread Raw
In response to Re: Why overlaps is not working  (Richard Broersma Jr <rabroersma@yahoo.com>)
Responses Overlap flags (Was: Re: Why overlaps is not working)
Re: Why overlaps is not working
List pgsql-general
> What you meant to test is:
>
>  select (date '20060101'::timestamp,
>     coalesce(NULL, 'infinity'::timestamp))
>  overlaps
>  (date '20060102'::timestamp,
>     coalesce(NULL, 'infinity'::timestamp))
>
> Which returns true.

Alban,

If first period end and second period start dates are the same, I need that in this case expression
returns true.
Is it possible to implement this using OVERLAPS operator ?

Andrus.


pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: Why overlaps is not working
Next
From: Alban Hertroys
Date:
Subject: Overlap flags (Was: Re: Why overlaps is not working)