aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_tr_update_approved_flag
Parameters
Name
Type
Mode
Definition
begin if ( tg_op = 'INSERT' or new.room_rate is distinct from old.room_rate or new.extrabed_rate is distinct from old.extrabed_rate or new.child_rate is distinct from old.child_rate or new.mealtype_id is distinct from old.mealtype_id ) then update public.registration set approved = false where id = new.register_id; end if; return null; end;