mapas
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_propagate_opportunity_update()
Parameters
Name
Type
Mode
IN
Definition
BEGIN UPDATE opportunity SET registration_ranges = NEW.registration_ranges, registration_categories = NEW.registration_categories, registration_proponent_types = NEW.registration_proponent_types WHERE (parent_id = OLD.id OR id = OLD.parent_id) AND ( registration_ranges::jsonb IS DISTINCT FROM NEW.registration_ranges::jsonb OR registration_categories::jsonb IS DISTINCT FROM NEW.registration_categories::jsonb OR registration_proponent_types::jsonb IS DISTINCT FROM NEW.registration_proponent_types::jsonb ); RETURN NEW; END;