2013/5/26 bricklen <brick...@gmail.com>: > > 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 random() limit 1;
somewhat shorter: SELECT (random() * 5)::INT Ian Barwick -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
