From: | Tomek Zielonka <tomek-lists(at)mult(dot)i(dot)pl> |
---|---|
To: | PostgreSQL SQL <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: random |
Date: | 2001-03-07 12:56:48 |
Message-ID: | 20010307135648.A1172@mult.i.pl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Andrzej Roszkowski | 2001-03-07 14:03:59 | sql functions and triggers |
Previous Message | Tomek Zielonka | 2001-03-07 11:50:36 | Re: random |