On 5/16/12 1:40 AM, Brar Piening wrote:
> Misa Simic wrote:
>> I think result is ok... 2010-01-04 is not inside first range...
>
> Staring at my query for five minutes obviously didn't prevent me from
> creating that noise.
>
> I meant to query "SELECT '[2010-03-15,2010-05-22)'::daterange *
> '[2010-04-01,)'::daterange AS intersection;" which gives the expected
> result.
>
> Sorry for the noise!
Thanks for testing! You've inadvertently done a positive test, which is
a good thing ...
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com