On Fri, Apr 3, 2009 at 2:10 PM, Alvaro Herrera <alvhe...@commandprompt.com> wrote: > 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 .. >
and the same in HEAD PS: the analyze not always brings the problems, i had to turn off enable_mergejoin and enable_nestloop -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
