On Tue, 4 May 2010, Tom Lane 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)And? Those aren't in any of the groups the first query identified.
Oops, I have confused 0.519xxx and 0.51119yyy numbers. Sorry for the noise. Regards, S. ******************************************************************* Sergey E. Koposov, PhD Institute for Astronomy, University of Cambridge, UK Web: http://lnfm1.sai.msu.ru/~math E-mail: math@xxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
