From: | "Jackson, DeJuan" <djackson(at)cpsgroup(dot)com> |
---|---|
To: | Mauro Bartolomeoli <mbarto(at)novacomp(dot)it> |
Cc: | pgsql-sql(at)postgreSQL(dot)org, PostgreSQL Hackers Mailing List <pgsql-hackers(at)hub(dot)org> |
Subject: | RE: [SQL] random tuple |
Date: | 1998-10-08 16:46:49 |
Message-ID: | F10BB1FAF801D111829B0060971D839F45FE9D@cpsmail |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers 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?
>
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
> ------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Brook Milligan | 1998-10-08 17:06:21 | man page installation patch |
Previous Message | dje | 1998-10-08 16:35:49 | JOBOP Software Development Consultant |
From | Date | Subject | |
---|---|---|---|
Next Message | Terry Mackintosh | 1998-10-08 18:06:00 | Re: [ADMIN] RE: [HACKERS] Re: [COMMITTERS] 'pgsql/doc/src/sgml protocol.sgml' |
Previous Message | Jackson, DeJuan | 1998-10-08 16:29:23 | RE: [HACKERS] Re: [COMMITTERS] 'pgsql/doc/src/sgml protocol.sgml' |