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 f25Koxx37853
	for <pgsql-sql@postgresql.org>; Mon, 5 Mar 2001 15:50:59 -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 f25Koq920716;
	Mon, 5 Mar 2001 15:50:52 -0500 (EST)
To: Jelle Ouwerkerk <jelle@openface.ca>
cc: pgsql-sql@postgresql.org
Subject: Re: random 
In-reply-to: <Pine.NEB.4.10.10103051400050.13137-100000@what.openface.ca> 
References: <Pine.NEB.4.10.10103051400050.13137-100000@what.openface.ca>
Comments: In-reply-to Jelle Ouwerkerk <jelle@openface.ca>
	message dated "Mon, 05 Mar 2001 14:12:15 -0500"
Date: Mon, 05 Mar 2001 15:50:52 -0500
Message-ID: <20713.983825452@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Archive-Number: 200103/59
X-Sequence-Number: 1704

Jelle Ouwerkerk <jelle@openface.ca> writes:
> Also, is there a way to randomize the order of a result set?

There's always
	SELECT * FROM foo ORDER BY random();

			regards, tom lane