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

0 vote171 views1 answer
Copy table dbeaver
SQL
0 vote210 views1 answer
Postgres call view
SQL
2 votes230 views1 answer
Rails execute sql
SQL
0 vote214 views1 answer
Calculate date and convert to yearsmysql
SQL
0 vote207 views2 answers
Avg() sql
SQL
0 vote248 views1 answer
SQL Hello, [firstname] [lastname]
SQL
1 vote224 views1 answer
Get count by weekly pivot table sql server
SQL
0 vote208 views2 answers
How to find max and min salary in sql
SQL
0 vote250 views1 answer
Install mysql on bash
SQL
1 vote195 views3 answers
Remove unique key from a table
SQL