Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f25LYZx44369
	for <pgsql-sql@postgresql.org>; Mon, 5 Mar 2001 16:34:36 -0500 (EST)
	(envelope-from tgl@sss.pgh.pa.us)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id f25LYW920935;
	Mon, 5 Mar 2001 16:34:32 -0500 (EST)
To: Bruce Momjian <pgman@candle.pha.pa.us>
cc: Jelle Ouwerkerk <jelle@openface.ca>, pgsql-sql@postgresql.org
Subject: Re: random 
In-reply-to: <200103052129.QAA03712@candle.pha.pa.us> 
References: <200103052129.QAA03712@candle.pha.pa.us>
Comments: In-reply-to Bruce Momjian <pgman@candle.pha.pa.us>
	message dated "Mon, 05 Mar 2001 16:29:12 -0500"
Date: Mon, 05 Mar 2001 16:34:31 -0500
Message-ID: <20932.983828071@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Archive-Number: 200103/67
X-Sequence-Number: 1712

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