Re: Random tuple? - Mailing list pgsql-novice

From Jon Jensen
Subject Re: Random tuple?
Date
Msg-id Pine.LNX.4.44.0210182312410.1312-100000@louche.swelter.net
Whole thread Raw
In response to Random tuple?  ("Brendan LeFebvre" <brendanl@iname.com>)
List pgsql-novice
On Fri, 18 Oct 2002, Brendan LeFebvre wrote:

> Is there available a routine, intrinsic or otherwise, that allows for simple
> extraction of one(1) random tuple from a given table or query-result?

How about:

SELECT * FROM your_table ORDER BY random() LIMIT 1

Jon


pgsql-novice by date:

Previous
From: "Brendan LeFebvre"
Date:
Subject: Random tuple?
Next
From: Josh Berkus
Date:
Subject: Re: Random tuple?