Results for “sed”

PostgresBulk changes & set operations

Copy selected rows into another table ↗

Postgres: INSERT SELECT performs a set-based copy with an explicit destination column list.

Postgres✓ Tested

SQLiteBulk changes & set operations

Copy selected rows into another table ↗

SQLite: INSERT SELECT performs a set-based copy with an explicit destination column list.

SQLite✓ Tested

SQL ServerDates & text

Count day boundaries between dates ↗

Compare date values with DATEDIFF.

DATEDIFF✓ Tested

JavaDates & time zones

Count days between two dates ↗

Java: Use ChronoUnit.DAYS for an elapsed count rather than a Period day component.

Java✓ Tested

JavaPrecise numeric calculations

Divide negative integers with floor rounding ↗

Java: floorDiv and floorMod provide consistent floor-based quotient and remainder.

Java✓ Tested

SQLiteJSON data

Expand a JSON array into rows ↗

Iterate array elements using a table-valued function.

json_each✓ Tested

PostgresJSON & arrays

Expand an array into rows ↗

Use WITH ORDINALITY to retain original element order.

unnest✓ Tested

PythonGetting Started

Explain a calculation with a comment ↗

Python: Keep the code executable while documenting why a fixed input is used.

Python✓ Tested

C#Getting Started

Explain a calculation with a comment ↗

C#: Keep the code executable while documenting why a fixed input is used.

C#✓ Tested

JavaGetting Started

Explain a calculation with a comment ↗

Java: Keep the code executable while documenting why a fixed input is used.

Java✓ Tested

JavaScriptGetting Started

Explain a calculation with a comment ↗

JavaScript: Keep the code executable while documenting why a fixed input is used.

JavaScript✓ Tested

TypeScriptGetting Started

Explain a calculation with a comment ↗

TypeScript: Keep the code executable while documenting why a fixed input is used.

TypeScript✓ Tested