Results for “generated column”
Small, practical examples. Search by task or narrow things down below.
Compute a generated column
Store inputs and derive a value from them.
generated column✓ Tested
Read values generated by INSERT
Capture an IDENTITY value with OUTPUT.
OUTPUT✓ Tested
Return an inserted row
Read generated data directly from INSERT.
RETURNING✓ Tested
Align a nested grid with its parent’s columns
CSS: Subgrid reuses the parent tracks for the nested grid’s covered span.
CSS✓ Tested
Apply a default when an insert omits a column
SQL: A default supplies an omitted value; an explicit NULL still follows the column’s nullability rules.
SQL✓ Tested
Apply a default when an insert omits a column
SQL Server: A default supplies an omitted value; an explicit NULL still follows the column’s nullability rules.
SQL Server✓ Tested
Apply a default when an insert omits a column
Postgres: A default supplies an omitted value; an explicit NULL still follows the column’s nullability rules.
Postgres✓ Tested
Apply a default when an insert omits a column
SQLite: A default supplies an omitted value; an explicit NULL still follows the column’s nullability rules.
SQLite✓ Tested
Compare two generated sorted streams
Bash Scripts: Process substitution lets a command consume another command’s output as a file-like input.
Bash Scripts✓ Tested
Create an index matching filter and ordering columns
SQL: Place the equality-filter column before the ordering column in this composite index.
SQL✓ Tested
Create an index matching filter and ordering columns
SQL Server: Place the equality-filter column before the ordering column in this composite index.
SQL Server✓ Tested
Create an index matching filter and ordering columns
Postgres: Place the equality-filter column before the ordering column in this composite index.
Postgres✓ Tested