aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_get_bedtype_js
Parameters
Name
Type
Mode
Definition
declare json_result json; prefix_pms_file_url text = fn_prop_config('PREFIX_URL_PMS_FILE'); begin select jsonb_agg(dataset) from ( SELECT bt.id, bt."name", bt.enabled, bt.code, fn_get_bed_image_url(bt.image, bt.image_url) as image_url FROM bed_type bt ) as dataset into json_result; return json_result; END;