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 vote318 views1 answer
Postgres delete from where date is greater than specific date
SQL
0 vote282 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
0 vote299 views2 answers
Avg() sql
SQL
2 votes323 views1 answer
Add default sql server
SQL
2 votes309 views4 answers
ModuleNotFoundError: No module named 'mysql'
SQL
6 votes351 views2 answers
Mysql execute file
SQL
0 vote384 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL
1 vote346 views1 answer
Update from table tsql
SQL
0 vote321 views1 answer
This week mysql
SQL
0 vote345 views1 answer
Show mysql account privilleges
SQL