Received: from Linux (Linux.novacomp.it [195.191.98.3]) by hub.org (8.8.8/8.8.8) with SMTP id LAA27417 for ; Thu, 8 Oct 1998 11:56:20 -0400 (EDT) (envelope-from mbarto@novacomp.it) Received: from wind.home.it by Linux with esmtp (Linux Smail3.2.0.101 #12) id m0zRJQW-000rJTC; Thu, 8 Oct 1998 18:00:32 +0100 (GMT+0100) Received: (from mbarto@localhost) by wind.home.it (8.8.7/8.8.7) id OAA08051; Thu, 8 Oct 1998 14:04:50 +0200 Message-ID: X-Mailer: XFMail 1.3 [p0] on Linux X-Priority: 3 (Normal) Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit MIME-Version: 1.0 In-Reply-To: Date: Thu, 08 Oct 1998 14:04:49 +0200 (CEST) Sender: mbarto@novacomp.it From: Mauro Bartolomeoli To: "Jackson, DeJuan" Subject: RE: [SQL] random tuple Cc: pgsql-sql@postgreSQL.org 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 ------------------------------------