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

14 votes344 views1 answer
Oracle alter table add column not null
SQL
1 vote385 views2 answers
Drop table with constraints
SQL
5 votes319 views1 answer
Sql asynchronous stored procedure call
SQL
0 vote327 views1 answer
Services.AddDbContext DataSource Sqlite
SQL
0 vote351 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
1 vote337 views2 answers
Postgres copy table from one schema to another
SQL
0 vote329 views2 answers
Sql trigger difference between for and after
SQL
0 vote314 views1 answer
Soql more than today
SQL
1 vote343 views1 answer
Convert epoch to date in sql server
SQL
2 votes337 views1 answer
How to create sql database
SQL