Re: [HACKERS] 'infinity' in GiST index

2005-05-05 Thread Tom Lane
Oleg Bartunov 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 case yo

Re: [HACKERS] 'infinity' in GiST index

2005-05-05 Thread Oleg Bartunov
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 dist

Re: [HACKERS] 'infinity' in GiST index

2005-05-05 Thread Andrew - Supernews
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 nu

Re: [HACKERS] 'infinity' in GiST index

2005-05-05 Thread Dave Held
> -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&#x

Re: [HACKERS] 'infinity' in GiST index

2005-05-04 Thread Tom Lane
Oleg Bartunov 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 ? Seems li