Skip to content

sql: add support for Postgres geometric types #21286

@hjames9

Description

@hjames9

Add support for various geometric column types, similiar to PostgreSQL.

The types would be the following:

  • point (Point on a plane) -> (x,y)
  • line (Infinite line) -> {A,B,C}
  • lseg (Finite line segment) -> ((x1,y1),(x2,y2))
  • box (Rectangular box) -> ((x1,y1),(x2,y2))
  • path (Closed path) -> ((x1,y1),...)
  • path (Open path) -> [(x1,y1),...]
  • polygon (Multiple points) -> ((x1,y1),...)
  • circle (center point and radius) -> <(x,y),r>

PostgreSQL geometric type documentation: https://www.postgresql.org/docs/10/static/datatype-geometric.html

Issue is a nice to have for my use cases

Jira issue: CRDB-5891

Metadata

Metadata

Assignees

No one assigned

    Labels

    A-sql-datatypesSQL column types usable in table descriptors.A-sql-pgcompatSemantic compatibility with PostgreSQLC-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)O-communityOriginated from the communityT-spatialSpatial TeamX-anchored-telemetryThe issue number is anchored by telemetry references.meta-issueContains a list of several other issues.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions