From: | Karel Riveron Escobar <kescobar(at)estudiantes(dot)uci(dot)cu> |
---|---|
To: | bricklen <bricklen(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Random numbers |
Date: | 2013-05-25 16:04:48 |
Message-ID: | b029097f-dcfd-4ef0-bdb0-8b573bee4aee@ucimail4.uci.cu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks bricklen.
I found another way in PostgreSQL 9.1.0 Documentation.
SELECT * INTO random_number FROM random(); -- random function gives me a random value among 0.0 -- and 1.0
SELECT * INTO rounded_number FROM round(random_number * 5); -- this line is completly obviously.
Saludos, Karel Riverón
Consejo Científico Estudiantil
Universidad de las Ciencias Informáticas
----- Original Message -----
| From: "bricklen" <bricklen(at)gmail(dot)com>
| To: "Karel Riveron Escobar" <kescobar(at)estudiantes(dot)uci(dot)cu>
| Cc: pgsql-general(at)postgresql(dot)org
| Sent: Saturday, May 25, 2013 11:50:03 AM
| Subject: Re: [GENERAL] Random numbers
| On Sat, May 25, 2013 at 8:45 AM, Karel Riveron Escobar <
| kescobar(at)estudiantes(dot)uci(dot)cu > wrote:
| | I want to generate random numbers in Pl/pgSQL. How can I do this?
|
| | To be more specific, I have to generate random numbers among 0 and
| | 5.
|
| One way:
| select n from unnest(ARRAY[0,1,2,3,4,5]) n order by random() limit 1;
From | Date | Subject | |
---|---|---|---|
Next Message | Szymon Guz | 2013-05-25 16:10:52 | Re: Random numbers |
Previous Message | Ian Lawrence Barwick | 2013-05-25 15:56:52 | Re: Random numbers |