mapas
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
random_id_generator(table_name character varying, initial_range bigint)
Parameters
Name
Type
Mode
table_name
character varying
IN
initial_range
bigint
IN
Definition
DECLARE rand_int INTEGER; count INTEGER := 1; statement TEXT; BEGIN WHILE count > 0 LOOP initial_range := initial_range * 10; rand_int := (RANDOM() * initial_range)::BIGINT + initial_range / 10; statement := CONCAT('SELECT count(id) FROM ', table_name, ' WHERE id = ', rand_int); EXECUTE statement; IF NOT FOUND THEN count := 0; END IF; END LOOP; RETURN rand_int; END;