Skip site navigation (1) Skip section navigation (2)

BUG #3469: SELECT QRY

From: "SRIDHARAN" <sridharan(at)avanttec(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3469: SELECT QRY
Date: 2007-07-18 11:34:51
Message-ID: 200707181134.l6IBYpXP048604@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      3469
Logged by:          SRIDHARAN
Email address:      sridharan(at)avanttec(dot)net
PostgreSQL version: 1.4.2
Operating system:   WinXP
Description:        SELECT QRY
Details: 

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

But it is : t
How to acheive correct result


SELECT (DATE '2007-07-30', DATE '2007-08-01') OVERLAPS (DATE '2007-07-31',
DATE '2007-07-31')
Returns : t

Responses

pgsql-bugs by date

Next:From: JairoDate: 2007-07-18 11:51:40
Subject: BUG #3471: Failed to set permissions on created files
Previous:From: Heikki LinnakangasDate: 2007-07-18 09:50:10
Subject: Re: BUG #3467: Sum strange behaviour

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group