On 25 May 2013 18:14, Karel Riveron Escobar wrote:
> How would be if I would want to generate values among 3 and 5?
>
>
>
Hi Karel,
try something like:
SELECT floor(3 + random()*(5-3+1))::INT
Or generally:
CREATE OR REPLACE FUNCTION
random_range(INTEGER, INTEGER) RETURNS INTEGER
AS $$
SELEC
Riveron Escobar"
| , pgsql-general@postgresql.org
| Sent: Saturday, May 25, 2013 12:10:52 PM
| Subject: Re: [GENERAL] Random numbers
| On 25 May 2013 17:56, Ian Lawrence Barwick < barw...@gmail.com >
| wrote:
| | 2013/5/26 bricklen < brick...@gmail.com >:
|
| | >
|
| | > On Sat, May
On 25 May 2013 17:56, Ian Lawrence Barwick wrote:
> 2013/5/26 bricklen :
> >
> > On Sat, May 25, 2013 at 8:45 AM, Karel Riveron Escobar
> > 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
Riverón
Consejo Científico Estudiantil
Universidad de las Ciencias Informáticas
- Original Message -
| From: "bricklen"
| To: "Karel Riveron Escobar"
| Cc: pgsql-general@postgresql.org
| Sent: Saturday, May 25, 2013 11:50:03 AM
| Subject: Re: [GENERAL] Random numbe
2013/5/26 bricklen :
>
> On Sat, May 25, 2013 at 8:45 AM, Karel Riveron Escobar
> 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 orde
On Sat, May 25, 2013 at 8:45 AM, Karel Riveron Escobar <
kesco...@estudiantes.uci.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 r
Hello list,
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.
Thanks in advance.
Regards, Karel Riverón
Student Scientific Council
Informatics Science University
http://www.uci.cu
