cockroachdb / cockroachdb/cockroach
sql: add support for `inet_ops` inverted index
Open
C-enhancement
O-support
P-3
T-sql-queries
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
This issue tracks adding support for indexing the `inet_ops` [operator class](https://www.postgresql.org/docs/current/gist-builtin-opclasses.html). This is useful for operators like `>>` (containment), for which there isn't currently a way to avoid a full-table-scan. Note that CRDB already supports the operations themselves (see `inet_contains_or_equals` [here](https://www.cockroachlabs.com/docs/v23.2/functions-and-operators#bool-functions), for example), but is unable to inline them into an index scan.
Related to #35730
Jira issue: CRDB-37844
Contributor guide
Assessment
This issue has not been assessed yet.