"Sergey E. Koposov" <math@xxxxxxxxxx> writes: > On Tue, 4 May 2010, Tom Lane wrote: >> They aren't; or at least you've not provided any evidence that they were. > I think I did, since: > ## select id ,count(*) from tmpx group by (id) having count(*)>1; > id | count > --------------------+------- > 0.519465064629912 | 2 > 0.0100625408813357 | 2 > 0.394671014975756 | 2 > (3 rows) > and > ## select id from tmpx where id > 0.51119 and id < 0.51120; > id > ------------------- > 0.511193082667887 > 0.511194097343832 > (2 rows) And? Those aren't in any of the groups the first query identified. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general