| From: | Mauro Bartolomeoli <mbarto(at)novacomp(dot)it> |
|---|---|
| To: | "Jackson, DeJuan" <djackson(at)cpsgroup(dot)com> |
| Cc: | pgsql-sql(at)postgreSQL(dot)org |
| Subject: | RE: [SQL] random tuple |
| Date: | 1998-10-08 12:04:49 |
| Message-ID: | XFMail.981008140449.mbarto@wind.home.it |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)novacomp(dot)it
ICQ#: 9602542
------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jackson, DeJuan | 1998-10-08 16:29:23 | RE: [HACKERS] Re: [COMMITTERS] 'pgsql/doc/src/sgml protocol.sgml' |
| Previous Message | bisheng | 1998-10-08 05:04:37 |