Re: consistent random order - Mailing list pgsql-sql

From Michael Fuhr
Subject Re: consistent random order
Date
Msg-id 20061130075822.GA85484@winnie.fuhr.org
Whole thread Raw
In response to Re: consistent random order  (Jeff Herrin <jeff@alternateimage.com>)
Responses Re: consistent random order
List pgsql-sql
On Wed, Nov 29, 2006 at 12:32:56PM -0500, Jeff Herrin wrote:
> I don't think cursors are going to help in this case. The order
> by random() is still going to give different result sets on different
> pages.

Have you tried using setseed() to seed the random number generator
to the same value before each query?

-- 
Michael Fuhr


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: SQL command join question
Next
From: "Bart Degryse"
Date:
Subject: Re: UNICODE and PL/PGSQL