-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 04, 2005 11:17 PM
To: Oleg Bartunov
Cc: Pgsql Hackers
Subject: Re: [HACKERS] 'infinity' in GiST index
[...]
Seems like it's not really GiST's fault but a definitional problem
for the timestamp
On 2005-05-05, Dave Held [EMAIL PROTECTED] wrote:
That's because you're talking about transfinite arithmetic, and
subtraction is not defined therein. AKA the arithmetic of
infinite cardinals. I've actually seen a few different
formulations, some of which say that adding a finite number to
On Thu, 5 May 2005, Dave Held wrote:
but I doubt GiST will be happy if we make the datatype behave
that way...
I guess it depends on why you want to take the difference. If
you want to take some measure of distance, it might be useful
to say that all infinite values of the same sign are at 0
Oleg Bartunov oleg@sai.msu.su writes:
On Thu, 5 May 2005, Dave Held wrote:
I guess it depends on why you want to take the difference. If
you want to take some measure of distance, it might be useful
to say that all infinite values of the same sign are at 0 distance
from each other, in which
Hi there,
there was complain about problem with creating GiST index if
timestamp column contains 'infinity' value. The problem is indeed
exists and I'd like to have it fixed, but we have no idea
how to handle it in GiST, actually in penalty function.
Any thoughts ?
Regards,
Oleg Bartunov oleg@sai.msu.su writes:
there was complain about problem with creating GiST index if
timestamp column contains 'infinity' value. The problem is indeed
exists and I'd like to have it fixed, but we have no idea
how to handle it in GiST, actually in penalty function.
Any thoughts