More fun with random selects

From: Darren Greer <dgreer(at)websightsolutions(dot)com>
To: pgsql-sql(at)postgreSQL(dot)org
Subject: More fun with random selects
Date: 1999-06-30 12:27:02
Message-ID: 9906300730281H.06064@george
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Browse pgsql-sql by date

  From Date Subject
Next Message Dirk Drechsel 1999-06-30 12:49:32 [SQL] Port?
Previous Message José Soares 1999-06-30 12:08:53 Re: [SQL] begin/end/abort work for sequences?