On May 21, 4:49 am, "Andrus" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
