Re: PG & random() strangeness

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