eperusteetamosaa
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
jsonb_lower_keys(obj jsonb)
Parameters
Name
Type
Mode
obj
jsonb
IN
Definition
BEGIN IF obj IS NULL THEN RETURN NULL; ELSIF jsonb_typeof(obj) = 'object' THEN RETURN ( SELECT jsonb_object_agg(lower(key), jsonb_lower_keys(value)) FROM jsonb_each(obj) ); ELSIF jsonb_typeof(obj) = 'array' THEN RETURN ( SELECT jsonb_agg(jsonb_lower_keys(elem)) FROM jsonb_array_elements(obj) elem ); ELSE RETURN obj; END IF; END;