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@sai.msu.ru