[
https://issues.apache.org/jira/browse/CALCITE-5585?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17703714#comment-17703714
]
Tanner Clary commented on CALCITE-5585:
---------------------------------------
[~julianhyde] Ah yes I think I misunderstood. I removed a lot of what I had and
added an entry to the convertlet table as you suggested. Feel free to take a
look when you get a chance. Thanks.
> Add STRPOS() Function (Enabled for BigQuery)
> --------------------------------------------
>
> Key: CALCITE-5585
> URL: https://issues.apache.org/jira/browse/CALCITE-5585
> Project: Calcite
> Issue Type: Improvement
> Reporter: Tanner Clary
> Assignee: Tanner Clary
> Priority: Major
> Labels: pull-request-available
> Time Spent: 1h 10m
> Remaining Estimate: 0h
>
> BigQuery supports the {{STRPOS()}} function with accepts 2 {{character
> strings}} as arguments. The function returns the 1-based position of the
> first occurrence of the second string within the first (example below). If no
> occurrence is found, the function returns 0. The function also supports
> {{binary strings}} with the same behavior. Note that {{STRPOS}} differs from
> the standard {{POSITION}} function in that it counts the position of the
> character in a {{binary string}}, not the position of a byte.
> EXAMPLE: {{STRPOS("abc", "bc")}} would return: {{2}}.
> EXAMPLE: {{STRPOS("abc", "d")}} would return: {{0}}.
> [BigQuery
> docs|https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#strpos]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
