Postgres Pro
Downloads
Home   >   mailing lists

Re: random - Mailing list pgsql-sql

From Tom Lane
Subject Re: random
Date
Msg-id 20932.983828071@sss.pgh.pa.us
Whole thread Raw
In response to Re: random  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: random  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-sql
Tree view 
Bruce Momjian <pgman@candle.pha.pa.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

pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: random
Next
From: Mathijs Brands
Date:
Subject: Re: Optimizing Query