| 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: | Whole Thread | Raw Message | 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 |