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 vote175 views1 answer
Sql server bool select
SQL
0 vote192 views1 answer
Limit in access query
SQL
0 vote210 views1 answer
Login failed for user sql server
SQL
0 vote221 views1 answer
Connect to nginx server mysql remotly
SQL
0 vote185 views1 answer
SQL SERVER SELECT BETWEEN DATETIME
SQL
0 vote206 views1 answer
The fetch keyword oracle
SQL
11 votes224 views3 answers
Change column name sql server management studio
SQL
0 vote255 views1 answer
Manage Database in MySQL
SQL
8 votes195 views1 answer
Oracle search stored procedures for text
SQL
0 vote244 views1 answer
Sql select rows between 1000 and 2000
SQL