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