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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs