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

James Howe ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5a09867... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiOWEwMzEwOWYz... ) / New Feature ( https://hibernate.atlassian.net/browse/HHH-14140?atlOrigin=eyJpIjoiOWEwMz... ) HHH-14140 ( https://hibernate.atlassian.net/browse/HHH-14140?atlOrigin=eyJpIjoiOWEwMz... ) Dialect for core PostgreSQL geometric types ( https://hibernate.atlassian.net/browse/HHH-14140?atlOrigin=eyJpIjoiOWEwMz... ) 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=5a09867... ) 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=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-14140#add-comment?atlOrigin=ey... ) 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.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=Em... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100141- sha1:76df2fe )