aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_sellable_statuses
Parameters
Name
Type
Mode
Definition
with status as ( select fn_sys_param('ROOM_STATUS','SELLABLE', '[]'::json)::json as sellable ) Select case when coalesce(json_array_length(sellable),0) = 0 then '{CL,IS,PU}'::text[] else ARRAY(SELECT json_array_elements_text(sellable)) end from status