Skip to content

Support the DuckDB MAP type #600

@JelteF

Description

@JelteF

Description

Postgres does not support a generic MAP type. So we need to make some concessions here. But what we can do is the following:

  1. If people actually select a MAP column in the output of their query, we should probably just convert it to its text representation.
  2. To allow operations on it like indexing, should define a new Postgres type called duckdb.map and implement the index/subscript operator on it. That subscript operator should then return a duckdb.unresolved_type, similarly to how the index/subscript operator is implemented on duckdb.unresolved_type.

Once we do this we can un-exclude:

Metadata

Metadata

Assignees

No one assigned

    Labels

    typesIssues related to type conversions

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions