Re: PG & random() strangeness

From: "Sergey E(dot) Koposov" <math(at)sai(dot)msu(dot)ru>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PG & random() strangeness
Date: 2010-05-04 16:38:20
Message-ID: alpine.LRH.2.00.1005042036500.27603@lnfm1.sai.msu.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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(at)sai(dot)msu(dot)ru

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2010-05-04 17:48:25 Re: (psuedo) random serial for PK or at least UNIQUE NOT NULL?
Previous Message Marc Schablewski 2010-05-04 16:33:54 Re: PG & random() strangeness