Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: consistent random order
- From: Michael Fuhr <mike(at)fuhr(dot)org>
- To: Jeff Herrin <jeff(at)alternateimage(dot)com>
- Cc: Andreas Kretschmer <akretschmer(at)spamfence(dot)net>, pgsql-sql(at)postgresql(dot)org
- Subject: Re: consistent random order
- Date: Thu, 30 Nov 2006 00:58:23 -0700
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
- Follow-Ups:
- Re: consistent random order
- From: Jeff Herrin
- Re: consistent random order
- References:
- Re: consistent random order
- From: Andreas Kretschmer
- Re: consistent random order
- From: Jeff Herrin
- Re: consistent random order
- Prev by Date: Re: SQL command join question
- Next by Date: Re: UNICODE and PL/PGSQL
- Previous by thread: Re: consistent random order
- Next by thread: Re: consistent random order
- Indexes: