Received: from bjke.com (firewall-user@ganymede.bjke.com [144.210.8.38]) by hub.org (8.8.8/8.8.8) with ESMTP id MAA08696 for ; Wed, 7 Oct 1998 12:37:03 -0400 (EDT) (envelope-from djackson@cpsgroup.com) Received: by bjke.com; id LAA27106; Wed, 7 Oct 1998 11:36:59 -0500 (CDT) Received: from cpsmail.cpsgroup.com(144.210.12.11) by gauntlet.bjke.com via smap (4.1) id xmaa26223; Wed, 7 Oct 98 11:36:01 -0500 Received: by cpsmail with Internet Mail Service (5.0.1458.49) id <4KHRJRT3>; Wed, 7 Oct 1998 11:38:21 -0500 Message-ID: From: "Jackson, DeJuan" To: Mauro Bartolomeoli , pgsql-sql@postgreSQL.org Subject: RE: [SQL] random tuple Date: Wed, 7 Oct 1998 11:38:19 -0500 X-Priority: 3 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.0.1458.49) Content-Type: text/plain > 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(). -DEJ