Home > mailing lists

Random Select from PostgreSQL db - Mailing list pgsql-novice

From	Kris-Jon Fenton
Subject	Random Select from PostgreSQL db
Date	January 2, 2002 03:14:32
Msg-id	EPEFICNFACCLFNPJCLLJMEMGCDAA.kfenton@pcpro.net.au Whole thread Raw
List	pgsql-novice

Tree view

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

pgsql-novice by date:

From: Francisco Reyes
Date: 31 December 2001, 16:13:59
Subject: Re: appropriate sort_mem & shared buffers

From: "Jules Alberts"
Date: 02 January 2002, 08:49:52
Subject: some questions about PostgreSQL in general

Random Select from PostgreSQL db - Mailing list pgsql-novice

Previous

Next