Qi Zhu created CALCITE-6663:
-------------------------------
Summary: Support SPLIT_PART function for postgresql
Key: CALCITE-6663
URL: https://issues.apache.org/jira/browse/CALCITE-6663
Project: Calcite
Issue Type: Improvement
Reporter: Qi Zhu
{{We can support split_part function for postgresq:}}
{{split_part}} ( _{{string}}_ {{{}text{}}}, _{{delimiter}}_ {{{}text{}}},
_{{n}}_ {{integer}} ) → {{text}}
Splits _{{string}}_ at occurrences of _{{delimiter}}_ and returns the
{_}{{n}}{_}'th field (counting from one), or when _{{n}}_ is negative, returns
the |{_}{{n}}{_}|'th-from-last field.
{{split_part('abc~@~def~@~ghi', '~@~', 2)}} → {{def}}
{{split_part('abc,def,ghi,jkl', ',', -2)}} → {{ghi}}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
