Postgres Pro
Downloads
Home   >   mailing lists

Re: Random via Subselect or Temporary Table - Mailing list pgsql-general

From Thomas T. Thai
Subject Re: Random via Subselect or Temporary Table
Date
Msg-id 1488.63.226.186.156.1060400660.squirrel@mail.minnesota.com
Whole thread Raw
In response to Re: Random via Subselect or Temporary Table  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
<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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: 7.3.3 behaving differently on OS X 10.2.6 and FreeBSD
Next
From: "Marcelo Soares"
Date:
Subject: One table in two different databases