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 vote176 views1 answer
Oracle first row
SQL
0 vote185 views2 answers
Python mysql create table if not exists
SQL
0 vote180 views1 answer
Mariadb cast null to 0
SQL
0 vote199 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL
0 vote171 views1 answer
Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]
SQL
0 vote172 views1 answer
Change default schema sql server
SQL
0 vote181 views1 answer
Openquery insert into linked server
SQL
0 vote179 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL
2 votes172 views1 answer
Sql to char function with date
SQL
27 votes220 views5 answers
Mysql set password for user
SQL