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