Results for “bounded”
Small, practical examples. Search by task or narrow things down below.
Keep only the most recent items
Python: Use a bounded deque to discard the oldest item as new values arrive.
Python✓ Tested
Page an ordered result
Skip rows and fetch a bounded page.
OFFSET✓ Tested
Read the last value of the complete partition
SQL: Specify an unbounded-following frame so LAST_VALUE does not stop at the current row.
SQL✓ Tested
Read the last value of the complete partition
SQL Server: Specify an unbounded-following frame so LAST_VALUE does not stop at the current row.
SQL Server✓ Tested
Read the last value of the complete partition
Postgres: Specify an unbounded-following frame so LAST_VALUE does not stop at the current row.
Postgres✓ Tested
Read the last value of the complete partition
SQLite: Specify an unbounded-following frame so LAST_VALUE does not stop at the current row.
SQLite✓ Tested
Reject NaN and infinite values
PowerShell: Double.IsFinite excludes numeric values unsuitable for ordinary bounded calculations.
PowerShell✓ Tested
Take a limited number of iterator values
Python: Use islice to consume only the requested prefix of a potentially unbounded iterator.
Python✓ Tested
Validate a complete identifier with a regex
C#: Use absolute anchors and a timeout so the regex checks the complete input with a bounded execution time.
C#✓ Tested