mapas
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
pseudo_random_id_generator()
Parameters
Name
Type
Mode
IN
Definition
DECLARE l1 int; l2 int; r1 int; r2 int; VALUE int; i int:=0; BEGIN VALUE:= nextval('pseudo_random_id_seq'); l1:= (VALUE >> 16) & 65535; r1:= VALUE & 65535; WHILE i < 3 LOOP l2 := r1; r2 := l1 # ((((1366 * r1 + 150889) % 714025) / 714025.0) * 32767)::int; l1 := l2; r1 := r2; i := i + 1; END LOOP; RETURN ((r1 << 16) + l1); END;