Postgres Pro
Downloads
Home   >   mailing lists

selecting random rows - Mailing list pgsql-general

From Joseph Shraibman
Subject selecting random rows
Date
Msg-id 3F610D80.9040101@selectacast.net
Whole thread Raw
Responses Re: selecting random rows  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: selecting random rows  (Dennis Gearon <gearond@fireserve.net>)
Re: selecting random rows  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: selecting random rows  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
Tree view 
Is there a way to get random rows besides ORDER BY random()?  The problem with ORDER BY
random() is that is has to get all the rows from the table before the results are returned.

pgsql-general by date:

Previous
From: Joseph Shraibman
Date:
Subject: Re: NFS performance tuning
Next
From: Network Administrator
Date:
Subject: Re: Picture with Postgres and Delphi