Horton
Menu

Re: Random via Subselect or Temporary Table

Thomas T. Thai <tom@minnesota.com>

View thread
From: "Thomas T. Thai" <tom@minnesota.com>
To: <pgsql-general@postgresql.org>
Date: 2003-08-09T03:44:20Z
Lists: pgsql-general 
<quote who="Tom Lane">

> I'd suggest using DISTINCT ON (catnum) with ORDER BY catnum, random().
> See the SELECT reference page's "weather reports" example for
> background.

Good suggestion. Thank you Tom.

Thomas