Re: BUG #4748: hash join and sort-merge join make different results

Roman Kononov <kononov@ftml.net> writes:
> On 2009-04-03 14:57 Tom Lane said the following:
>> I think we could fix this by having interval_hash() duplicate the
>> total-span calculation done by interval_cmp_internal, and then return
>> the hash of the resulting TimeOffset.  This is going to break existing
>> hash indexes on intervals, but there seems little choice...

> Consider hashing the result of justify_interval().

Uh, what's your point?  We have to match interval_eq, not
justify_interval.

            regards, tom lane