-
Notifications
You must be signed in to change notification settings - Fork 4.1k
sql: add support for Postgres geometric types #21286
Copy link
Copy link
Open
Labels
A-sql-datatypesSQL column types usable in table descriptors.SQL column types usable in table descriptors.A-sql-pgcompatSemantic compatibility with PostgreSQLSemantic compatibility with PostgreSQLC-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)O-communityOriginated from the communityOriginated from the communityT-spatialSpatial TeamSpatial TeamX-anchored-telemetryThe issue number is anchored by telemetry references.The issue number is anchored by telemetry references.meta-issueContains a list of several other issues.Contains a list of several other issues.
Description
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
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
A-sql-datatypesSQL column types usable in table descriptors.SQL column types usable in table descriptors.A-sql-pgcompatSemantic compatibility with PostgreSQLSemantic compatibility with PostgreSQLC-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)O-communityOriginated from the communityOriginated from the communityT-spatialSpatial TeamSpatial TeamX-anchored-telemetryThe issue number is anchored by telemetry references.The issue number is anchored by telemetry references.meta-issueContains a list of several other issues.Contains a list of several other issues.