Postgresql random number

CREATE OR REPLACE FUNCTION random_between(low INT ,high INT) 
   RETURNS INT AS
$$
BEGIN
   RETURN floor(random()* (high-low + 1) + low);
END;
$$ language 'plpgsql' STRICT;

Source: postgresqltutorial.com

Postgresql random number

SELECT floor(random() * (h-l+1) + l)::int;

Source: postgresqltutorial.com

Generate random data postgresql

insert into towns (
    code, article, name, department
)
select
    left(md5(i::text), 10),
    md5(random()::text),
    md5(random()::text),
    left(md5(random()::text), 4)
from generate_series(1, 1000000) s(i)

Source: stackoverflow.com

Similar codes

1 vote219 views1 answer
Apex select list ORA-20999
SQL
3 votes235 views2 answers
Oracle drop sequence
SQL
1 vote194 views1 answer
Oracle sql create view
SQL
0 vote225 views1 answer
Convert sqlalchemy.util._collections to list of string
SQL
1 vote192 views1 answer
"i_am_a_dummy flag" in MySQL
SQL
0 vote200 views1 answer
Oracle NLS_CHARACTERSET
SQL
4 votes199 views1 answer
To date oracle with time
SQL
3 votes205 views1 answer
Insert into table from another table mysql
SQL
7 votes211 views3 answers
Sql server reset auto increment
SQL
26 votes450 views6 answers
Modify column name in sql
SQL