| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Sergey E(dot) Koposov" <math(at)sai(dot)msu(dot)ru> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: PG & random() strangeness |
| Date: | 2010-05-04 16:33:04 |
| Message-ID: | 14410.1272990784@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Sergey E. Koposov" <math(at)sai(dot)msu(dot)ru> writes:
> On Tue, 4 May 2010, Tom Lane wrote:
>> They aren't; or at least you've not provided any evidence that they were.
> I think I did, since:
> ## 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.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc Schablewski | 2010-05-04 16:33:54 | Re: PG & random() strangeness |
| Previous Message | Sergey E. Koposov | 2010-05-04 16:24:26 | Re: PG & random() strangeness |