Results for “json_each”
Small, practical examples. Search by task or narrow things down below.
Repeat while a condition holds
TypeScript: Count down while a positive number remains, updating the loop variable on each iteration.
TypeScript✓ Tested
Repeat while a condition holds
C++: Count down while a positive number remains, updating the loop variable on each iteration.
C++✓ Tested
Repeat while a condition holds
C: Count down while a positive number remains, updating the loop variable on each iteration.
C✓ Tested
Replace all matching text
Normalize repeated whitespace with a regular expression.
regexp_replace✓ Tested
Replace text with sed
Replace all occurrences of the substring old on each line and print the transformed text without changing the input file.
sed✓ Tested
Return an inserted row
Read generated data directly from INSERT.
RETURNING✓ Tested
Reuse an LED action with a function
Arduino / C: Put a short LED sequence in a named function and call it twice.
Arduino / C✓ Tested
Round a timestamp down to its month
Group dates by a calendar boundary.
date_trunc✓ Tested
Search a small FTS5 table
Use SQLite’s full-text index to match a term.
FTS5✓ Tested
Search text without case sensitivity
Match a pattern with PostgreSQL ILIKE.
ILIKE✓ Tested
Select a range of array elements
Bash Scripts: Quote a sliced at-sign expansion to keep each selected element separate.
Bash Scripts✓ Tested
Select object properties
Create a smaller object with only the fields you need.
Select-Object✓ Tested