Results for “Type & reading flow”
Small, practical examples. Search by task or narrow things down below.
Repeat the first ordered value beside each row
Postgres: FIRST_VALUE reads the first value in the current window frame.
Postgres✓ Tested
Repeat the first ordered value beside each row
SQLite: FIRST_VALUE reads the first value in the current window frame.
SQLite✓ Tested
Repeat while a condition holds
C++: Count down while a positive number remains, updating the loop variable on each iteration.
C++✓ Tested
Replace one collection element
C++: Update an existing element at a known valid index.
C++✓ Tested
Replace text using captured regex groups
C++: Numbered replacement groups can rearrange a known two-part name.
C++✓ Tested
Represent a record with a dataclass
Python: Generate initialization and convert a typed record to a dictionary.
Python✓ Tested
Represent an absent result with optional
C++: value_or supplies a default without requiring a sentinel inside the value domain.
C++✓ Tested
Require two conditions to be true
C++: Combine a lower and an upper bound to check whether a value is in range.
C++✓ Tested
Retrieve the result of an asynchronous task
C++: The explicit async launch policy requests asynchronous execution rather than deferred evaluation.
C++✓ Tested
Return an inserted row
Read generated data directly from INSERT.
RETURNING✓ Tested
Return the first item with a generic function
Preserve the element type while allowing empty arrays.
generics✓ Tested
Rotate a sequence around a selected position
C++: rotate places the element at the middle iterator first while preserving the two segment orders.
C++✓ Tested