Re: random

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jelle Ouwerkerk <jelle(at)openface(dot)ca>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: random
Date: 2001-03-05 20:50:52
Message-ID: 20713.983825452@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Jelle Ouwerkerk <jelle(at)openface(dot)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

In response to

  • random at 2001-03-05 19:12:15 from Jelle Ouwerkerk

Responses

  • Re: random at 2001-03-05 21:04:35 from Bruce Momjian

Browse pgsql-sql by date

  From Date Subject
Next Message Justin Long 2001-03-05 20:56:26 Optimizing Query
Previous Message wade 2001-03-05 19:51:22 pl/pgsql and returning rows