Re: random

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Jelle Ouwerkerk <jelle(at)openface(dot)ca>, pgsql-sql(at)postgresql(dot)org
Subject: Re: random
Date: 2001-03-05 21:34:31
Message-ID: 20932.983828071@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> But random returns a random value from 0-1, right? How does that work
> in ORDER BY?

What's the problem? Each row gets a different random value, then we
sort.

regards, tom lane

In response to

  • Re: random at 2001-03-05 21:29:12 from Bruce Momjian

Responses

  • Re: random at 2001-03-05 21:45:37 from Bruce Momjian

Browse pgsql-sql by date

  From Date Subject
Next Message Mathijs Brands 2001-03-05 21:40:29 Re: Optimizing Query
Previous Message Bruce Momjian 2001-03-05 21:29:12 Re: random