Re: random - Mailing list pgsql-sql

From Tomek Zielonka
Subject Re: random
Date
Msg-id 20010307135648.A1172@mult.i.pl
Whole thread Raw
In response to Re: random  (Tomek Zielonka <tomek-lists@mult.i.pl>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Tomek Zielonka
Date:
Subject: Re: random
Next
From: Andrzej Roszkowski
Date:
Subject: sql functions and triggers