Quick Links

selecting random rows

From:	Joseph Shraibman <jks(at)selectacast(dot)net>
To:	pgsql-general(at)postgresql(dot)org
Subject:	selecting random rows
Date:	2003-09-12 00:04:16
Message-ID:	3F610D80.9040101@selectacast.net
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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.

Responses

Re: selecting random rows at 2003-09-12 00:26:56 from Bruce Momjian
Re: selecting random rows at 2003-09-12 00:33:45 from Dennis Gearon
Re: selecting random rows at 2003-09-12 01:34:19 from Tom Lane
Re: selecting random rows at 2003-09-12 14:57:36 from scott.marlowe

Browse pgsql-general by date

	From	Date	Subject
Next Message	Network Administrator	2003-09-12 00:05:38	Re: Picture with Postgres and Delphi
Previous Message	Joseph Shraibman	2003-09-11 23:57:59	Re: NFS performance tuning