Re: ----??? Random ??? - Mailing list pgsql-novice

From Horst Herb
Subject Re: ----??? Random ???
Date
Msg-id 01073114065604.02026@munin.gnumed.dhs.org
Whole thread Raw
In response to ----??? Random ???  ("macky" <macky@edsamail.com>)
List 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


pgsql-novice by date:

Previous
From: Mithun Bhattacharya
Date:
Subject: [Re: Re: Postgresql & Redhat 6.2 = memory leak?]
Next
From: "macky"
Date:
Subject: RANDOM function?