cockroachdb / cockroachdb/cockroach
sql: support multirange types
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
Multirange types were [introduced in PostgreSQL 14](https://www.postgresql.org/docs/current/rangetypes.html#RANGETYPES-BUILTIN) and allow storing multiple non-contiguous, non-overlapping ranges in a single value. Each built-in range type has a corresponding multirange type (e.g. `int4multirange`, `tsmultirange`, `datemultirange`).
Reference: https://www.npgsql.org/efcore/mapping/range.html
Note that CockroachDB does not yet support range types either (#27791). Multirange support would naturally build on top of range type support.
This was surfaced by 12 npgsql test failures after bumping `server_version` from 13.0.0 to 18.0.0 (#169041) — npgsql now expects multirange types to be available.
Epic: CRDB-60812
Jira issue: CRDB-63371
Contributor guide
Assessment
This issue has not been assessed yet.