RE: [SQL] random tuple - Mailing list pgsql-sql

From Mauro Bartolomeoli
Subject RE: [SQL] random tuple
Date
Msg-id XFMail.981008140449.mbarto@wind.home.it
Whole thread Raw
In response to RE: [SQL] random tuple  ("Jackson, DeJuan" <djackson@cpsgroup.com>)
List pgsql-sql
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
------------------------------------

pgsql-sql by date:

Previous
From: bisheng
Date:
Subject: ...
Next
From: "Jackson, DeJuan"
Date:
Subject: RE: [HACKERS] Re: [COMMITTERS] 'pgsql/doc/src/sgml protocol.sgml'