| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> |
| Cc: | Dave Held <dave(dot)held(at)arraysg(dot)com>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: 'infinity' in GiST index |
| Date: | 2005-05-05 20:33:37 |
| Message-ID: | 25404.1115325217@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Oleg Bartunov <oleg(at)sai(dot)msu(dot)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 case you would say that +w - +w = 0.
>> Probably infinities of opposite signs should just be w apart
>> (which is also mathematically consistent).
> actually, it's timestamp_mi function rise the error which prevent
> GiST index creation.
Right --- the question is why is GIST calling that function.
What do you really need it to do?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2005-05-05 20:36:12 | Re: 'kitchen sink' downloads (Was: Re: [pgsql-advocacy] Increased company involvement) |
| Previous Message | Sergey E. Koposov | 2005-05-05 20:30:30 | Re: performance of bitmap scans in nested loop joins |