Re: ----??? Random ???

From: Horst Herb <hherb(at)malleenet(dot)net(dot)au>
To: "macky" <macky(at)edsamail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: ----??? Random ???
Date: 2001-07-31 04:06:56
Message-ID: 01073114065604.02026@munin.gnumed.dhs.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Tuesday 31 July 2001 13:50, you wrote:
> i want to populate a column with unique random numbers.... is there a
> function rhat gives me random unique numbers....??

Yes, Surprisingly ;-) it is called random().

gnumed2=# select random();
random
-------------------
0.635214479935921
(1 row)

gnumed2=# create table test(number float);
CREATE
gnumed2=# insert into test values(random());
INSERT 505549 1

Horst

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message macky 2001-07-31 05:41:43 RANDOM function?
Previous Message Mithun Bhattacharya 2001-07-31 04:03:42 [Re: Re: Postgresql & Redhat 6.2 = memory leak?]