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 vote402 views2 answers
Create more than 1 tables with references to each other in sqlite3
SQL
3 votes347 views1 answer
Dbms_scheduler drop_job
SQL
5 votes344 views2 answers
Oracle rename table
SQL
1 vote412 views1 answer
OSError: mysql_config not found
SQL
1 vote349 views1 answer
Table infromation in sql server
SQL
1 vote351 views1 answer
Multiple count in sql
SQL
0 vote351 views1 answer
Ajax error exception handeling
SQL
1 vote354 views1 answer
Postgres start database on linux
SQL
0 vote354 views1 answer
Write a query to peint the pattern P(20)
SQL
3 votes331 views1 answer
Delete all content in table mysql
SQL