select 2 random rows

From: Rory Campbell-Lange <rory(at)campbell-lange(dot)net>
To: Postgresql Novice List <pgsql-novice(at)postgresql(dot)org>
Subject: select 2 random rows
Date: 2002-06-27 22:42:06
Message-ID: 20020627224206.GA5479@campbell-lange.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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(at)campbell-lange(dot)net>
<www.campbell-lange.net>

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message stev knowles 2002-06-27 22:42:33 command length?
Previous Message Josh Berkus 2002-06-27 22:37:03 Re: Date Question