JetBrains / JetBrains/Exposed

Custom data type through Postgis function

Open
#937 3 comments 0 reactions 0 assignees View on GitHub
to be documented
Dominant language
Kotlin
Stars
9.3k
Forks
798
Avg merge
4d 2h
Merged PRs (30d)
26

Description

Hello,
I would like to create custom ColumnType for geo point from postgis. Now, when I read point i have to use PostGIS functions:
ST_X(ST_TRANSFORM(table.geometry,4674)) AS LONG,
ST_Y(ST_TRANSFORM(table.geometry,4674)) AS LAT,

table.geometry is my column with type GEOMETRY.
Is there a way to do it? I was looking at some custom ColumnTypes like Java date time, but I couldn't figure it out. Thanks!

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.