aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_tr_booking_update_booking_name
Parameters
Name
Type
Mode
Definition
BEGIN IF NEW.group_id IS NOT NULL THEN NEW.booking_name := (SELECT name FROM group_info WHERE id = NEW.group_id); ELSE NEW.booking_name := (SELECT full_name FROM guest WHERE id = NEW.guest_id); END IF; RETURN NEW; END