Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group