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 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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
