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
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? |