News for hackers. Stuff that matters.

A comment on Modern SQL: With – Organize Complex Queries. Parent comment

Re:Modern SQL: With – Organize Complex Queries by colanderman on Tuesday November 24, 2015 @09:22AM (#10620808)
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.)

[ Parent | on HN ]

There are no comments on this comment yet.