[
https://issues.apache.org/jira/browse/CALCITE-5262?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17600090#comment-17600090
]
Bertil Chapuis edited comment on CALCITE-5262 at 9/4/22 7:02 PM:
-----------------------------------------------------------------
I'd like to be able to implicitly transform a string into a geometry so that
one can write the following query:
{{SELECT ST_AsText('POINT(-71.064544 42.28787)');}}
Instead of:
{{SELECT ST_AsText(ST_GeomFromText('POINT(-71.064544 42.28787)'));}}
Both Postgis and H2Gis supports this kind of conversion. Should I introduce a
new SqlTypeTranform (TO_GEOMETRY)? Thanks a lot for your help, I'm still
discovering the internals of calcite.
was (Author: bchapuis):
I'd like to be able to implicitly transform a string into a geometry so that
one can write the following query:
SELECT ST_AsText('POINT(-71.064544 42.28787)');
Instead of:
SELECT ST_AsText(ST_GeomFromText('POINT(-71.064544 42.28787)'));
Both Postgis and H2Gis supports this kind of conversion. Should I introduce a
new SqlTypeTranform (TO_GEOMETRY)? Thanks a lot for your help, I'm still
discovering the internals of calcite.
> Add functions to support WKB (well-known binary) and GeoJSON
> ------------------------------------------------------------
>
> Key: CALCITE-5262
> URL: https://issues.apache.org/jira/browse/CALCITE-5262
> Project: Calcite
> Issue Type: Bug
> Components: spatial
> Reporter: Julian Hyde
> Assignee: Bertil Chapuis
> Priority: Major
>
> Add functions to support WKB (well-known binary) and GeoJSON. This is made
> possible by the switch to JTS in CALCITE-4294. The functions are:
> * ST_AsEWKT
> * ST_AsGeoJSON
> * ST_AsWKB
> * ST_GeomFromGeoJSON
> * ST_GeomFromWKB
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
