Hi, On 04.05.2010 18:24, Sergey E. Koposov wrote: > ## 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) The range in your second query does not include any of the duplicated values from your first query.
Kind regards, Marc -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
