Postgres Pro
Downloads
Home   >   mailing lists

Re: random - Mailing list pgsql-sql

From Tom Lane
Subject Re: random
Date
Msg-id 20713.983825452@sss.pgh.pa.us
Whole thread Raw
In response to random  (Jelle Ouwerkerk <jelle@openface.ca>)
Responses Re: random  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-sql
Tree view 
Jelle Ouwerkerk <jelle@openface.ca> writes:
> Also, is there a way to randomize the order of a result set?

There's alwaysSELECT * FROM foo ORDER BY random();
        regards, tom lane

pgsql-sql by date:

Previous
From: wade
Date:
Subject: pl/pgsql and returning rows
Next
From: Justin Long
Date:
Subject: Optimizing Query