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 vote282 views2 answers
Sql server find all foreign keys that reference a column
SQL
0 vote202 views1 answer
Install mysql for fedora 34
SQL
0 vote369 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote194 views4 answers
Mysql desactivar trigger
SQL
7 votes219 views1 answer
Oracle reset sequence
SQL
0 vote204 views4 answers
Postgresql between month
SQL
0 vote249 views1 answer
T-SQL Create Trigger
SQL
2 votes201 views3 answers
Current month mysql query
SQL
1 vote202 views1 answer
Adding a default constraint to an existing column in sql
SQL
2 votes202 views2 answers
Sql first character
SQL