Skip to content

Add support for multirange column type #10556

@nielsstinissen

Description

@nielsstinissen

Feature Description

There currently is no support for multirange column type in postgressql
(More explanation https://www.postgresql.org/docs/current/rangetypes.html#RANGETYPES-CONSTRUCT)

Currently only range types are supported (eg. daterange) on which GiST index can be used.

The Solution

Add support for mulitrange types.
This also would make it possible to query over multiple ranges

Considered Alternatives

Let array: true create a multirange column instead of range column

Additional Context

No response

Relevant Database Driver(s)

  • aurora-mysql
  • aurora-postgres
  • better-sqlite3
  • cockroachdb
  • cordova
  • expo
  • mongodb
  • mysql
  • nativescript
  • oracle
  • postgres
  • react-native
  • sap
  • spanner
  • sqlite
  • sqlite-abstract
  • sqljs
  • sqlserver

Are you willing to resolve this issue by submitting a Pull Request?

Yes, I have the time, but I don't know how to start. I would need guidance.

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions