Re: BUG #4748: hash join and sort-merge join make different results - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #4748: hash join and sort-merge join make different results
Date
Msg-id 9358.1238822702@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #4748: hash join and sort-merge join make different results  (Roman Kononov <kononov@ftml.net>)
List pgsql-bugs
Roman Kononov <kononov@ftml.net> writes:
> On 2009-04-03 23:32 Tom Lane said the following:
>> Uh, what's your point?  We have to match interval_eq, not
>> justify_interval.

> For any two intervals a and b, saying that interval_cmp_interval(a,b)==0
> is exactly the same as saying that (aj.month==bj.month && aj.day==bj.day
> && aj.time==bj.time), where aj=justify_interval(a) and
> bj=justify_interval(b).

I doubt that that's exactly true when you take floating-point roundoff
into account ...

            regards, tom lane

pgsql-bugs by date:

Previous
From: Roman Kononov
Date:
Subject: Re: BUG #4748: hash join and sort-merge join make different results
Next
From: Devrim GÜNDÜZ
Date:
Subject: Re: MD5 checksum or RPM for PostgreSQL 8.7.3