Postgres Pro
Downloads
Home   >   mailing lists

strange result for select * from table where id=random()*900 - Mailing list pgsql-sql

From Stefan Zweig
Subject strange result for select * from table where id=random()*900
Date
Msg-id 156384696@web.de
Whole thread Raw
Responses Re: strange result for select * from table where id=random()*900  (Tommy Gildseth <tommy.gildseth@usit.uio.no>)
Re: strange result for select * from table where id=random()*900  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
Re: strange result for select * from table where id=random()*900  (Kristo Kaiv <kristo.kaiv@skype.net>)
List pgsql-sql
Tree view 
hi list,

this is my query:

select 
*
from _g2977 
where 
id=floor(random() * (900));

in table _g2977 i have id(s) from 1 up to 900. i just want to select one random dataset by the above query but i does
notwork.
 

actually i get sometime zero, sometimes one, sometimes two and sometimes even three results back from the above query
althoughi thought it should give only one random dataset from the table.
 

what is wrong?

i appreciate any help.

thanks in advance, stefan
_________________________________________________________________________
In 5 Schritten zur eigenen Homepage. Jetzt Domain sichern und gestalten! 
Nur 3,99 EUR/Monat! http://www.maildomain.web.de/?mc=021114

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: unique index on fields with possible null values
Next
From: Tommy Gildseth
Date:
Subject: Re: strange result for select * from table where id=random()*900