From: Stefan Zweig <stefanzweig1881@web.de>
To: pgsql-sql@postgresql.org
Subject: strange result for select * from table where id=random()*900
Date: Fri, 27 Jul 2007 09:48:41 +0200
Message-ID: <156384696@web.de> (raw)
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 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: stefanzweig1881@web.de
Subject: Re: strange result for select * from table where id=random()*900
In-Reply-To: <156384696@web.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox