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