Re: Random()

Поиск
Список
Период
Сортировка
Искать
От
Aaron Bono
Тема
Re: Random()
Дата
Msg-id
bf05e51c0611171514o10891569n4008704562ca55fe@mail.gmail.com
Ответ на
Re: Random() (A. Kretschmer)
Список
Дерево обсуждения
Random() "Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com>
Re: Random() "A. Kretschmer" <andreas.kretschmer@schollglas.com>
Re: Random() "Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com>
Re: Random() "Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com>
Re: Random() Andrew Sullivan <ajs@crankycanuck.ca>
Re: Random() "Rajesh Kumar Mallah" <mallah.rajesh@gmail.com>
Re: Random() "A. Kretschmer" <andreas.kretschmer@schollglas.com>
Re: Random() "Rajesh Kumar Mallah" <mallah.rajesh@gmail.com>
Re: Random() "Aaron Bono" <postgresql@aranya.com>
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 по дате отправления
От: lms
Дата:
Сообщение: Re: How convert UNICODE
От: Rajesh Kumar Mallah
Дата:
FAQ