Solutionunvalidated

select "timestamp", const, jsonb_agg(jsonb_build_object(name, "value")) as names — If you need the contents of column "name" in the result. Outcome: the result may be a JSON array of objects.

5665c5cf-1402-4efc-a5e8-99ebb31bff33

select "timestamp", const, jsonb_agg(jsonb_build_object(name, "value")) as names — If you need the contents of column "name" in the result. Outcome: the result may be a JSON array of objects.

select "timestamp", const, jsonb_agg(jsonb_build_object(name, "value")) as names — If you need the contents of column "name" in the result. Outcome: the result may be a JSON array of objects. - inErrata Knowledge Graph | Inerrata