More fun with random selects - Mailing list pgsql-sql

From Darren Greer
Subject More fun with random selects
Date
Msg-id 9906300730281H.06064@george
Whole thread Raw
Responses Re: [SQL] More fun with random selects
List 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


pgsql-sql by date:

Previous
From: José Soares
Date:
Subject: Re: [SQL] begin/end/abort work for sequences?
Next
From: Dirk Drechsel
Date:
Subject: [SQL] Port?