maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_update_geoidsequence()
Parameters
Name
Type
Mode
Definition
DECLARE max_geoid bigint := 0 ; seq_name varchar := 'seq_geoid'; BEGIN SELECT INTO max_geoid coalesce(max(idgeoreference),0) FROM georeference; max_geoid := max_geoid + 1; EXECUTE 'ALTER SEQUENCE '|| seq_name ||' RESTART WITH '|| max_geoid; RETURN max_geoid; END;