*** This version of Confluence is for testing only and contains a copy of content from June 29th 2026. No changes will be preserved. ***
...
ORDER BY name, jsonb_extract_path_text (values.jsonb,'id'), jsonb_extract_path_text (values.jsonb,'value')
---- can also use: ORDER BY name, values.jsonb #>> '{id}', values.jsonb #>> '{value}'
4. Extracting Arrays - Alternative to using cross joins, and how to prevent records without the array elements from dropping out
...