> 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?
> 
Never seen them before but it looks like:
    oidsrand(int4) -- seeds the random number generator for oidrand to
use
    oidrand(oid, int4) -- returns a psudo-random oid

The parameters to oidrand I can't figure out.
Anybody else?
		-DEJ
> ---
> 
> ------------------------------------
>  Mauro Bartolomeoli
>  e-mail: mbarto(at)novacomp(dot)it
>  ICQ#: 9602542
> ------------------------------------

Responses

• Re: [HACKERS] RE: [SQL] random tuple at 1998-10-09 04:43:55 from Thomas G. Lockhart

pgsql-hackers by date

Next:	From: Brook Milligan	Date: 1998-10-08 17:06:21
	Subject: man page installation patch
Previous:	From: dje	Date: 1998-10-08 16:35:49
	Subject: JOBOP Software Development Consultant

pgsql-sql by date

Next:	From: Terry Mackintosh	Date: 1998-10-08 18:06:00
	Subject: Re: [ADMIN] RE: [HACKERS] Re: [COMMITTERS] 'pgsql/doc/src/sgml protocol.sgml'
Previous:	From: Jackson, DeJuan	Date: 1998-10-08 16:29:23
	Subject: RE: [HACKERS] Re: [COMMITTERS] 'pgsql/doc/src/sgml protocol.sgml'