Random Select from PostgreSQL db

From: "Kris-Jon Fenton" <kfenton(at)pcpro(dot)net(dot)au>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Random Select from PostgreSQL db
Date: 2002-01-02 05:11:04
Message-ID: EPEFICNFACCLFNPJCLLJMEMGCDAA.kfenton@pcpro.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi all,

I asked a few days ago how to select a random row from a table.

I am using PostgreSQL and PHP.

This time I need to pull testimonials randomly from a database.

I know that you can do it with MySQL by using random() but how can I pull
random rows from PosgreSQL.

Thanks
Kris

Browse pgsql-novice by date

  From Date Subject
Next Message Jules Alberts 2002-01-02 10:41:24 some questions about PostgreSQL in general
Previous Message Francisco Reyes 2001-12-31 18:02:43 Re: appropriate sort_mem & shared buffers