JSON Macro

json_group_object()

Arguments & returns

`json_group_object(n, v)`

Macro

Overload link	`n`	`v`	Returns
#01	`unknown`	`unknown`	`unknown`

Example

SELECT json_group_object(fruit, quantity) AS harvest
FROM (VALUES ('apples', 12), ('pears', 8))
  AS data(fruit, quantity);

Haybarn WASM 1.5.5-rc3 · In your browser

Guide example · Run to view results.

Definition

CAST(
  (
    (
      '{' || string_agg(
        (
          (
            CASE
              WHEN ((n IS NULL)) THEN ("error" ('json_group_object key cannot be NULL'))
              ELSE to_json(CAST(n AS VARCHAR))
            END || ':'
          ) || CASE
            WHEN ((v IS NULL)) THEN (CAST('null' AS "JSON"))
            ELSE to_json(v)
          END
        ),
        ','
      )
    ) || '}'
  ) AS "JSON"
)