Re: Random() - Mailing list pgsql-sql

From Aaron Bono
Subject Re: Random()
Date
Msg-id bf05e51c0611171514o10891569n4008704562ca55fe@mail.gmail.com
Whole thread Raw
In response to Re: Random()  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-sql
On 11/16/06, A. Kretschmer <andreas.kretschmer@schollglas.com> wrote:
am  Thu, dem 16.11.2006, um 16:31:14 -0200 mailte Ezequias Rodrigues da Rocha folgendes:
> Hi list,
>
> I have a bigint collumn and I would like to generate a random number within the
> numbers of my column.

select <bigint_column> from <your_table> order by random() limit 1;

Is this a PostgreSQL thing or is it SQL standard?

--
==================================================================
   Aaron Bono
   Aranya Software Technologies, Inc.
   http://www.aranya.com
   http://codeelixir.com
==================================================================

pgsql-sql by date:

Previous
From: "lms"
Date:
Subject: Re: How convert UNICODE
Next
From: "Rajesh Kumar Mallah"
Date:
Subject: transactional shared variable in postgresql