Thread: RE: [SQL] random tuple

RE: [SQL] random tuple

From
"Jackson, DeJuan"
Date:
> Is there any way to select a random row from a table using an SQL
> query?
> I'm using Postgresql 6.3.2.
>
I'd look at using cursors and random().
    -DEJ

RE: [SQL] random tuple

From
Mauro Bartolomeoli
Date:
On 07-Oct-98 Jackson, DeJuan wrote:
>> Is there any way to select a random row from a table using an SQL
>> query?
>> I'm using Postgresql 6.3.2.
>>
> I'd look at using cursors and random().

It's a good idea. Do you (or someone else) know how to use the following
PostgreSQL functions: oidrand(oid,int4) ,oidsrand(int4)? What are they
intended for and what is their result?

---

------------------------------------
 Mauro Bartolomeoli
 e-mail: mbarto@novacomp.it
 ICQ#: 9602542
------------------------------------