3 ms·
You mean like SELECT key, value1, ARRAY(SELECT value2 FROM bar WHERE bar.key = foo.key) AS value2_array FROM foo; ? (In Postgres; no "J
by colanderman 11y ago
You mean like
SELECT key, value1,
ARRAY(SELECT value2 FROM bar WHERE bar.key = foo.key)
AS value2_array
FROM foo;
?
(In Postgres; no "JSON capabilities" needed.)