[
https://issues.apache.org/jira/browse/CALCITE-5281?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17602549#comment-17602549
]
Julian Hyde commented on CALCITE-5281:
--------------------------------------
I noticed that the [ST_Explode examples in
H2GIS|http://www.h2gis.org/docs/dev/ST_Explode/] have queries and table names
in single-quoted strings. Idiomatic Calcite SQL would not quote the query. So:
{code}
-- ST_Explode using the 'tableName'
SELECT * FROM ST_Explode(TABLE test_point);
-- or
-- ST_Explode using a 'query'
SELECT * FROM ST_Explode(SELECT * FROM test_point
WHERE ST_Dimension(THE_GEOM)=0);
{code}
> Implement geometry set returning functions (SRF)
> ------------------------------------------------
>
> Key: CALCITE-5281
> URL: https://issues.apache.org/jira/browse/CALCITE-5281
> Project: Calcite
> Issue Type: Improvement
> Components: spatial
> Reporter: Bertil Chapuis
> Assignee: Bertil Chapuis
> Priority: Minor
>
> The idea is to implement set returning functions, such as ST_Explode in H2GIS
> and ST_Dump in PostGIS. Is the Uncollect class a good starting point?
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
