[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-bugs
Subject:    Re: [BUGS] BUG #3469: SELECT QRY
From:       Heikki Linnakangas <heikki () enterprisedb ! com>
Date:       2007-07-18 11:55:51
Message-ID: 469DFFC7.4080703 () enterprisedb ! com
[Download RAW message or body]

SRIDHARAN wrote:
> SELECT (DATE '2001-07-30', DATE '2001-08-31') OVERLAPS (DATE '2001-08-04',
> DATE '2002-08-04') 
> Retrutns : t
> 
> SELECT (DATE '2007-07-30', DATE '2007-07-31') OVERLAPS (DATE '2007-07-31',
> DATE '2007-07-31')
> Returns : f

That's intentional. SQL OVERLAPS operator treats the intervals as open
from the end-side.

-- 
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
[prev in list] [next in list] [prev in thread] [next in thread]