Hi,
On 04.05.2010 18:24, Sergey E. Koposov 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)
The range in your second query does not include any of the duplicated
values from your first query.
Kind regards,
Marc