Home > mailing lists

select 2 random rows - Mailing list pgsql-novice

From	Rory Campbell-Lange
Subject	select 2 random rows
Date	June 27, 2002 21:42:18
Msg-id	20020627224206.GA5479@campbell-lange.net Whole thread Raw
Responses	command length? (stev knowles <stev@Precision.Guesswork.COM>) Re: select 2 random rows (Josh Berkus <josh@agliodbs.com>)
List	pgsql-novice

Tree view

I'd like to select 2 random rows from a table.
At the moment I'm returning a couple of hundred rows into a perl hash
and randomising it there, but it would be great if I could do it in the
database call.

Each row has an id number created using the SERIAL type.

Thanks for any help.
Rory
--
Rory Campbell-Lange
<rory@campbell-lange.net>
<www.campbell-lange.net>

pgsql-novice by date:

From: Josh Berkus
Date: 27 June 2002, 21:34:46
Subject: Re: Date Question

From: stev knowles
Date: 27 June 2002, 21:56:19
Subject: command length?

select 2 random rows - Mailing list pgsql-novice

Previous

Next