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

Roman Kononov wrote:

> Description:        hash join and sort-merge join make different results
> Details:
>
> test-std=# create table t(s int,i interval);
> CREATE TABLE
> test-std=# insert into t values (0,'30 days'), (1,'1 month');
> INSERT 0 2
> test-std=# select * from t as a, t as b where a.i=b.i;

Reproducible in 8.2.13 as well ..

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support