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==================================================================