FIND YOUR NEXT FEW LINES
The snippet library.
Small, practical examples. Search by task or narrow things down below.
5 snippets foundClear filters
Build a JSON array from rows
Aggregate ordered text values into JSON.
json_group_array✓ Tested
Check whether text is valid JSON
Reject malformed input before processing it.
json_valid✓ Tested
Expand a JSON array into rows
Iterate array elements using a table-valued function.
json_each✓ Tested
Extract a JSON field
Read a scalar value from JSON text.
json_extract✓ Tested
Set a JSON property
Create an updated JSON document from existing text.
json_set✓ Tested