aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_tr_guest_fullname_changed
Parameters
Name
Type
Mode
Definition
BEGIN UPDATE booking bk SET booking_name = NEW.full_name WHERE bk.guest_id = NEW.id; --IF is_log_started() IS NOT NULL THEN PERFORM sp_append_log(fn_format_log('Guest Name', OLD.full_name, NEW.full_name)); --END IF; RETURN NULL; END