Received: from localhost (maia-2.hub.org [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id 6729A9FB1DD
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 30 Nov 2006 03:58:45 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024)
	with ESMTP id 57926-10 for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 30 Nov 2006 03:58:38 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158])
	by postgresql.org (Postfix) with ESMTP id 8EF179FA8EF
	for <pgsql-sql@postgresql.org>; Thu, 30 Nov 2006 03:58:38 -0400 (AST)
Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1])
	by tigger.fuhr.org (8.13.8/8.13.8) with ESMTP id kAU7wOFB011382
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK);
	Thu, 30 Nov 2006 00:58:26 -0700 (MST)
Received: from winnie.fuhr.org (localhost [127.0.0.1])
	by winnie.fuhr.org (8.13.8/8.13.8) with ESMTP id kAU7wNWC085543;
	Thu, 30 Nov 2006 00:58:23 -0700 (MST)
	(envelope-from mfuhr@winnie.fuhr.org)
Received: (from mfuhr@localhost)
	by winnie.fuhr.org (8.13.8/8.13.8/Submit) id kAU7wNmZ085542;
	Thu, 30 Nov 2006 00:58:23 -0700 (MST) (envelope-from mfuhr)
Date: Thu, 30 Nov 2006 00:58:23 -0700
From: Michael Fuhr <mike@fuhr.org>
To: Jeff Herrin <jeff@alternateimage.com>
Cc: Andreas Kretschmer <akretschmer@spamfence.net>, pgsql-sql@postgresql.org
Subject: Re: consistent random order
Message-ID: <20061130075822.GA85484@winnie.fuhr.org>
References: <20061129172742.GA9005@KanotixBox>
	<25133466.59111164821576601.JavaMail.root@srv161.carpathiahost.net>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <25133466.59111164821576601.JavaMail.root@srv161.carpathiahost.net>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200611/286
X-Sequence-Number: 26938

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