sql: support expression-based index columns · Issue #9682 · cockroachdb/cockroach (original) (raw)

Computed indexes are indexes on the result of an expression (as opposed to the direct value of a column). For example: CREATE INDEX a ON customer( LOWER(firstname) || ' ' || LOWER(lastname))

Suggested by @petermattis