Re: strange result for select * from table where id=random()*900
От | Kristo Kaiv |
---|---|
Тема | Re: strange result for select * from table where id=random()*900 |
Дата | |
Msg-id | B1941B8F-B359-4818-89FF-8966936E3FC0@skype.net обсуждение исходный текст |
Ответ на | strange result for select * from table where id=random()*900 (Stefan Zweig <stefanzweig1881@web.de>) |
Список | pgsql-sql |
On 27.07.2007, at 10:48, Stefan Zweig wrote:
hi list,this is my query:select*from _g2977whereid=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 not work.actually i get sometime zero, sometimes one, sometimes two and sometimes even three results back from the above query although i 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---------------------------(end of broadcast)---------------------------TIP 5: don't forget to increase your free space map settings
SELECT * FROM _g2977 g,
(SELECT floor(random() * (900) as rnd) r
WHERE g.id = r.rnd
should work better, haven't tested though.
Kristo Kaiv
http://kaiv.wordpress.com (PostgreSQL blog)
В списке pgsql-sql по дате отправления: