aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_age_range_json
Parameters
Name
Type
Mode
Definition
SELECT coalesce( jsonb_agg(jsonb_build_object( 'id', from_age, 'from_age', from_age, 'to_age', to_age, 'label', label ) ORDER BY from_age), '[]'::jsonb ) FROM public.age_range;