aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_get_department_group_json
Parameters
Name
Type
Mode
post_type
character
IN (DEFAULT 'P')
Definition
DECLARE v_result json; v_state text; v_message text; v_detail text; v_hint text; v_context text; BEGIN SELECT json_agg(json_build_object('id', dg.id, 'name', dg.name, 'category', dg.category) ORDER BY dg.seq) FROM department_group dg WHERE dg.post_type = $1 INTO v_result; RETURN coalesce(v_result, '[]'::json); EXCEPTION WHEN OTHERS THEN GET STACKED DIAGNOSTICS v_state = RETURNED_SQLSTATE, v_message = MESSAGE_TEXT, v_detail = PG_EXCEPTION_DETAIL, v_hint = PG_EXCEPTION_HINT, v_context = PG_EXCEPTION_CONTEXT; RETURN fn_handle_error(v_state, v_message, v_detail, v_hint, v_context, 'sp_get_department_group_json', null::jsonb); END