Postgres Pro
Downloads
Home   >   mailing lists

Re: selecting a random record - Mailing list pgsql-general

From Alexey Borzov
Subject Re: selecting a random record
Date
Msg-id 1496914841.20010207131219@rdw.ru
Whole thread Raw
In response to selecting a random record  (Culley Harrelson <culleyharrelson@yahoo.com>)
List pgsql-general
Tree view 
Greetings, Culley!

At 06.02.2001, 13:11, you wrote:

CH> Any suggestions on how to select a random record from
CH> any given table?
    SELECT * FROM any_given_table ORDER BY random() LIMIT 1;

--
Yours, Alexey V. Borzov, Webmaster of RDW

pgsql-general by date:

Previous
From: "Richard Huxton"
Date:
Subject: Re: Re: new type proposal
Next
From: Alexey Borzov
Date:
Subject: Re[2]: Re: new type proposal