signalo
.signalo_db
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ft_reorder_signs_in_frame()
Parameters
Name
Type
Mode
IN
Definition
DECLARE _rank integer := 1; _sign record; BEGIN FOR _sign IN (SELECT * FROM signalo_db.sign WHERE fk_frame = OLD.fk_frame ORDER BY rank ASC) LOOP UPDATE signalo_db.sign SET rank = _rank WHERE id = _sign.id; _rank = _rank + 1; END LOOP; RETURN OLD; END;