Re: doverlaps() returns null - Mailing list pgsql-general

From Rodrigo De León
Subject Re: doverlaps() returns null
Date
Msg-id 1179780141.674741.123150@x35g2000prf.googlegroups.com
Whole thread Raw
In response to Re: doverlaps() returns null  (Rodrigo De León <rdeleonp@gmail.com>)
List pgsql-general
On May 21, 4:49 am, "Andrus" <kobrule...@hot.ee> wrote:
> I'm using this for emplyment, vacation, illness etc. period calculation.
> OVERLAPS produces invalid result in this case for DATE as discussed in other
> thread.
>
> select doverlaps(date '2007-01-01',date '2007-01-02',date '2007-01-02',date
> '2007-01-04');
>
> returns  FALSE
>
> When first period end and second period start dates are the the same,
> doverlaps() must return TRUE.
>
> Andrus.

OR $2 = $3


pgsql-general by date:

Previous
From: PFC
Date:
Subject: feature suggestions
Next
From: "Ericson Smith"
Date:
Subject: What is "Postgresql Hot"?