aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_room_layout_json
Parameters
Name
Type
Mode
i_id
integer
IN
Definition
SELECT to_jsonb(rl) || jsonb_build_object('location_name', l.name) FROM public.room_layout rl LEFT JOIN public.room_location l ON l.id = rl.location_id WHERE rl.id = i_id;