9.2 Beta: intersection of daterange - Mailing list pgsql-hackers

From Brar Piening
Subject 9.2 Beta: intersection of daterange
Date
Msg-id 4FB35CB5.8000904@gmx.de
Whole thread Raw
List pgsql-hackers
I'm currently doing some tests on range types:

tests=# SELECT int8range(5,15) * int8range(10,20) AS intersection; intersection
-------------- [10,15)
(1 Zeile)


tests=#
tests=# SELECT '[2010-03-15,2010-05-22)'::daterange * 
'[2010-01-04,)'::daterange AS intersection;      intersection
------------------------- [2010-03-15,2010-05-22)
(1 Zeile)


Does the second query trigger a bug or am I misunderstanding something?

I would expect [2010-01-04,2010-05-22) as result.

Regards,

Brar


pgsql-hackers by date:

Previous
From: Volker Grabsch
Date:
Subject: Missing optimization when filters are applied after window functions
Next
From: Misa Simic
Date:
Subject: Re: 9.2 Beta: intersection of daterange