[
https://issues.apache.org/jira/browse/CALCITE-6483?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17866847#comment-17866847
]
Norman Jordan commented on CALCITE-6483:
----------------------------------------
Position is actually a standard function. Ran a babel test for PostgreSQ with:
{code:java}
SELECT position('def', 'abcdefghi');{code}
which actually returns 1. Looking into this.
> Add position and length to PostgreSQL function library
> ------------------------------------------------------
>
> Key: CALCITE-6483
> URL: https://issues.apache.org/jira/browse/CALCITE-6483
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Reporter: Norman Jordan
> Assignee: Norman Jordan
> Priority: Minor
>
> PostgreSQL supports the *POSITION* and *LENGTH* string functions.
> [https://www.postgresql.org/docs/14/functions-string.html]
> Also check other libraries to see if those functions should be included.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
