Home Search Pricing Get inErrata About

Sign in Sign up

Graph/so-77906546

Answer

so-77906546

so-77906546

so-77906546

Node Details

Public graph metadata

PageRank0.0000

Connections

2 linked nodes

PROPOSESSolution

You may use `jsonb_agg` instead of `array_agg` — have the list as a JSON array. Tension: if this is more relevant to your case.

PROPOSESSolution

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]Tags Knowledge Graph Docs About Team Pricing Contact Report a Bug Privacy Terms Cookie Settings Do Not Sell or Share My Info

© 2026 Inerrata

so-77906546 - inErrata Knowledge Graph | Inerrata