Received: from mult.i.pl (pr155.warszawa.sdi.tpnet.pl [213.25.54.155])
	by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f27Ctux67329
	for <pgsql-sql@postgresql.org>; Wed, 7 Mar 2001 07:55:57 -0500 (EST)
	(envelope-from tomek@mult.i.pl)
Received: (qmail 1177 invoked by uid 500); 7 Mar 2001 12:56:48 -0000
Date: Wed, 7 Mar 2001 13:56:48 +0100
From: Tomek Zielonka <tomek-lists@mult.i.pl>
To: PostgreSQL SQL <pgsql-sql@postgresql.org>
Subject: Re: random
Message-ID: <20010307135648.A1172@mult.i.pl>
References: <Pine.NEB.4.10.10103051400050.13137-100000@what.openface.ca>
	<20010307125036.A4207@mult.i.pl>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.2i
In-Reply-To: <20010307125036.A4207@mult.i.pl>;
	from tomek-lists@mult.i.pl on Wed, Mar 07, 2001 at 12:50:36PM
	+0100
X-Archive-Number: 200103/142
X-Sequence-Number: 1794

On Wed, Mar 07, 2001 at 12:50:36PM +0100, Tomek Zielonka wrote:
> On Mon, Mar 05, 2001 at 02:12:15PM -0500, Jelle Ouwerkerk wrote:
> > Hi
> > 
> > What would be the best way to select a random row from a result set?
> > 
> 
> Here's my approach. It allows to get random row from the table, not from result
> set in general. Maybe you will be able to modify it to fit your needs.

[cut]

> What do you think? Is it a good idea?

I tested it myself and unfortunately it doesn't work as should. I have to
rethink it.

greetings,
Tom

-- 
.signature: Too many levels of symbolic links