aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_set_param
Parameters
Name
Type
Mode
param_group
text
IN
param_name
text
IN
param_value
anyelement
IN
param_type
smallint
IN (DEFAULT 0)
Definition
BEGIN -- param_group := case param_name -- when 'AUTO_CONFIRM_BOOKING' then 'SYSTEM' -- when 'ALLOW_OVERBOOK' then 'SYSTEM' -- else param_group -- end; UPDATE property_info SET system_params = jsonb_set(system_params, ARRAY[coalesce(upper(param_group),'SYSTEM'), upper(param_name)], COALESCE(to_jsonb(param_value), 'null'::jsonb)); RETURN TRUE; END