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