Received: from bilbo.websightsolutions.com (dial200-7.mixcom.com [207.250.200.7] (may be forged)) by hub.org (8.9.3/8.9.3) with ESMTP id IAA99711 for ; Wed, 30 Jun 1999 08:29:10 -0400 (EDT) (envelope-from dgreer@websightsolutions.com) 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 HAA24701 for ; Wed, 30 Jun 1999 07:30:48 -0500 From: Darren Greer Reply-To: dgreer@websightsolutions.com Organization: Websight Solutions To: pgsql-sql@postgreSQL.org Subject: More fun with random selects Date: Wed, 30 Jun 1999 07:27:02 -0500 X-Mailer: KMail [version 1.0.21] Content-Type: text/plain MIME-Version: 1.0 Message-Id: <9906300730281H.06064@george> Content-Transfer-Encoding: 8bit Hello all. I have a question that has to do with getting a random number of rows from a table. I am already using oidrand(oid, #), to get a random percentage of rows from a table. What I want to do now is get a rand # of rows, where I pick the number. For example, lets say I want a random 125 rows from an existing table. Is there an easy way I can do that where I actually am getting a decent sample from the table? As always, any help is appreciated. Darren -- Darren Greer System Administrator - Applications Development Manager Websight Solutions Inc. Phone: (414) 790-9327 | Fax: (414) 790-5952