Re: BUG #3469: SELECT QRY

From: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
To: SRIDHARAN <sridharan(at)avanttec(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3469: SELECT QRY
Date: 2007-07-18 11:55:51
Message-ID: 469DFFC7.4080703@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2007-07-18 21:44:21 Re: BUG #3459: Query Error : plan should not reference subplan's variable
Previous Message Jairo 2007-07-18 11:51:40 BUG #3471: Failed to set permissions on created files