[hibernate-issues] [JIRA] (HHH-14140) Dialect for core PostgreSQL geometric types

[James Howe (JIRA)]

James Howe ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5a098673c66aa77b654a183c ) *created* an issue

Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiOWEwMzEwOWYzZGI5NGFiM2FjYWI4YjRjYTcwMWM1NTUiLCJwIjoiaiJ9 ) / New Feature ( https://hibernate.atlassian.net/browse/HHH-14140?atlOrigin=eyJpIjoiOWEwMzEwOWYzZGI5NGFiM2FjYWI4YjRjYTcwMWM1NTUiLCJwIjoiaiJ9 ) HHH-14140 ( https://hibernate.atlassian.net/browse/HHH-14140?atlOrigin=eyJpIjoiOWEwMzEwOWYzZGI5NGFiM2FjYWI4YjRjYTcwMWM1NTUiLCJwIjoiaiJ9 ) Dialect for core PostgreSQL geometric types ( https://hibernate.atlassian.net/browse/HHH-14140?atlOrigin=eyJpIjoiOWEwMzEwOWYzZGI5NGFiM2FjYWI4YjRjYTcwMWM1NTUiLCJwIjoiaiJ9 )

Issue Type: New Feature Assignee: Unassigned Components: hibernate-spatial Created: 07/Aug/2020 03:17 AM Labels: postgresql Priority: Major Reporter: James Howe ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5a098673c66aa77b654a183c )

Separate to the PostGIS extension currently supported by hibernate-spatial, there are also built-in geometric types and functions.

https://www.postgresql.org/docs/current/datatype-geometric.html
https://www.postgresql.org/docs/current/functions-geometry.html

Note that generated SQL should use the operators rather than their equivalent functions (e.g. @> instead of box_contain_pt ) otherwise the query planner will not make use of relevant indexes.

( https://hibernate.atlassian.net/browse/HHH-14140#add-comment?atlOrigin=eyJpIjoiOWEwMzEwOWYzZGI5NGFiM2FjYWI4YjRjYTcwMWM1NTUiLCJwIjoiaiJ9 ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-14140#add-comment?atlOrigin=eyJpIjoiOWEwMzEwOWYzZGI5NGFiM2FjYWI4YjRjYTcwMWM1NTUiLCJwIjoiaiJ9 )

Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.core&referrer=utm_source%3DNotificationLink%26utm_medium%3DEmail ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailNotificationLink&mt=8 ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100141- sha1:76df2fe )
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/hibernate-issues/attachments/20200807/12cfc866/attachment.html