On 11/16/06, A. Kretschmer <[EMAIL PROTECTED]> 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
==================================================================

Reply via email to