[
https://issues.apache.org/jira/browse/CALCITE-5585?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tanner Clary updated CALCITE-5585:
----------------------------------
Description:
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]
was:
BigQuery supports the {{STRPOS()}} function with accepts 2 {{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 ByteStrings with the same
behavior.
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]
> 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: 20m
> 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)
