Re: 9.2 Beta: intersection of daterange

From: Brar Piening <brar(at)gmx(dot)de>
To: Misa Simic <misa(dot)simic(at)gmail(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: 9.2 Beta: intersection of daterange
Date: 2012-05-16 08:40:19
Message-ID: 4FB367F3.1070602@gmx.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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!

Regards,

Brar

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Cave-Ayland 2012-05-16 10:25:20 Interrupting long external library calls
Previous Message Misa Simic 2012-05-16 08:27:41 Re: 9.2 Beta: intersection of daterange