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 vote147 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote154 views2 answers
The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue.
SQL
8 votes151 views2 answers
Oracle undo usage
SQL
1 vote150 views1 answer
Decalre temp table sql
SQL
5 votes177 views1 answer
Ora-00054 resource busy and acquire with nowait
SQL
0 vote156 views1 answer
How to inner join 4 tables in sql
SQL
3 votes161 views2 answers
How to open postgresql in windows
SQL
0 vote148 views1 answer
Get rows from 1 table with other table empty mysql
SQL
6 votes146 views2 answers
Mysql first day of month
SQL
0 vote164 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL