Re: overlaps() does not work as expected?

From: Alvaro Herrera <alvherre(at)surnet(dot)cl>
To: Mario Weilguni <mweilguni(at)sime(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: overlaps() does not work as expected?
Date: 2005-05-27 18:10:36
Message-ID: 20050527181036.GD10164@surnet.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, May 27, 2005 at 06:35:32PM +0200, Mario Weilguni wrote:
> I've quite some trouble with the overlaps function:
> SELECT overlaps('9.6.2005'::date, '9.6.2005'::date, '9.6.2005'::date,
> '9.6.2005'::date);
> returns true (these are german timestamps dd.mm.yyyy)
>
> SELECT overlaps('8.6.2005'::date, '9.6.2005'::date, '9.6.2005'::date,
> '9.6.2005'::date);
> returns false

I can reproduce it here. I'm not sure if this is a feature, but I don't
think so.

--
Alvaro Herrera (<alvherre[a]surnet.cl>)
"Siempre hay que alimentar a los dioses, aunque la tierra esté seca" (Orual)

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jochem van Dieten 2005-05-27 18:28:11 Re: overlaps() does not work as expected?
Previous Message Tom Lane 2005-05-27 16:49:27 Re: Cost of XLogInsert CRC calculations