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

From Alban Hertroys
Subject Re: Why overlaps is not working
Date
Msg-id 45533445.5040705@magproductions.nl
Whole thread Raw
In response to Why overlaps is not working  ("Andrus" <eetasoft@online.ee>)
Responses Re: Why overlaps is not working  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Andrus wrote:
> set datestyle to iso,iso;
>
> select 1 where ('2006-10-31'::date, '9999-12-31'::date) OVERLAPS
>    ('2006-10-16'::DATE, '2006-10-31':: DATE)
>
>
> does not return any rows.
>
> Why ?

They're adjacent, they don't overlap. Check the documentation on
OVERLAPS, I'm sure it's explicit about whether it is inclusive or
exclusive (the latter apparently).

> How to make overlaps to return correct result?

  select 1 where ('2006-10-30'::date, '9999-12-31'::date) OVERLAPS
     ('2006-10-16'::DATE, '2006-10-31':: DATE);
  ?column?
----------
         1
(1 row)

--
Alban Hertroys
alban@magproductions.nl

magproductions b.v.

T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
    7500 AK Enschede

// Integrate Your World //

pgsql-general by date:

Previous
From: Rick Schumeyer
Date:
Subject: database dump then restore on another system?
Next
From: "A. Kretschmer"
Date:
Subject: Re: Why overlaps is not working