Received: from trends.net (root@clio.trends.ca [209.47.148.2]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA03072 for ; Wed, 23 Jun 1999 10:38:08 -0400 (EDT) (envelope-from dgreer@websightsolutions.com) Received: from bilbo.websightsolutions.com (dial200-7.mixcom.com [207.250.200.7] (may be forged)) by trends.net (8.8.8/8.8.8) with ESMTP id JAA22472 for ; Wed, 23 Jun 1999 09:00:11 -0400 (EDT) Received: from george (root@george.websightsolutions.com [207.250.200.13]) by bilbo.websightsolutions.com (8.9.3/8.9.3/Debian/GNU) with SMTP id HAA18717 for ; Wed, 23 Jun 1999 07:56:18 -0500 From: Darren Greer Reply-To: dgreer@websightsolutions.com Organization: Websight Solutions To: pgsql-sql@postgreSQL.org Subject: oidrand question Date: Wed, 23 Jun 1999 06:54:20 -0500 X-Mailer: KMail [version 1.0.21] Content-Type: text/plain MIME-Version: 1.0 Message-Id: <9906230705310F.13060@george> Content-Transfer-Encoding: 8bit Hello again all. First I would like to thank all those who helped me with the multiple select statement. Thanks to your help, it is working fine. I am in the process of using oidrand inside of a select statement. However, I am noticing some wierd results when I feed certain numbers in. Here is a sample select statement. select * from listeners where station = 'KKLS' and oidrand(oid, 2); This returns, as expected, about 50% of the results. Another: select * from listeners where station = 'KKLS' and oidrand(oid, 3); This return about 33%. Now lets say that I want to get 75% of the results. I would put 1.333 in there, but it does not return 75%, it return 100%. This tells me that this is rounding to the nearest whole number. If so, how does one get say 75% of the results? Thanks, Darren