2013/5/26 bricklen <[email protected]>: > > On Sat, May 25, 2013 at 8:45 AM, Karel Riveron Escobar > <[email protected]> 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;
somewhat shorter: SELECT (random() * 5)::INT Ian Barwick -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
