Re: Random()

From: "Aaron Bono" <postgresql(at)aranya(dot)com>
To: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Random()
Date: 2006-11-17 23:14:51
Message-ID: bf05e51c0611171514o10891569n4008704562ca55fe@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 11/16/06, A. Kretschmer <andreas(dot)kretschmer(at)schollglas(dot)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
==================================================================

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Rajesh Kumar Mallah 2006-11-18 12:30:56 transactional shared variable in postgresql
Previous Message lms 2006-11-17 23:10:19 Re: How convert UNICODE