This is an automated email from the ASF dual-hosted git repository.
github-bot pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/arrow-datafusion.git
The following commit(s) were added to refs/heads/asf-site by this push:
new 40ddd105f4 Publish built docs triggered by
084fdfbeb7c1174b2ccee400a80bcddd6bac22dd
40ddd105f4 is described below
commit 40ddd105f4c51eb80c947b4af919ed1804734283
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Tue Jan 23 16:06:17 2024 +0000
Publish built docs triggered by 084fdfbeb7c1174b2ccee400a80bcddd6bac22dd
---
_sources/user-guide/sql/scalar_functions.md.txt | 32 +
searchindex.js | 2 +-
user-guide/sql/scalar_functions.html | 870 +++++++++++++-----------
3 files changed, 501 insertions(+), 403 deletions(-)
diff --git a/_sources/user-guide/sql/scalar_functions.md.txt
b/_sources/user-guide/sql/scalar_functions.md.txt
index 50e1cbc3d6..c3def3f89b 100644
--- a/_sources/user-guide/sql/scalar_functions.md.txt
+++ b/_sources/user-guide/sql/scalar_functions.md.txt
@@ -613,7 +613,9 @@ nullif(expression1, expression2)
- [concat](#concat)
- [concat_ws](#concat_ws)
- [chr](#chr)
+- [ends_with](#ends_with)
- [initcap](#initcap)
+- [instr](#instr)
- [left](#left)
- [length](#length)
- [lower](#lower)
@@ -756,6 +758,20 @@ chr(expression)
**Related functions**:
[ascii](#ascii)
+### `ends_with`
+
+Tests if a string ends with a substring.
+
+```
+ends_with(str, substr)
+```
+
+#### Arguments
+
+- **str**: String expression to test.
+ Can be a constant, column, or function, and any combination of string
operators.
+- **substr**: Substring to test for.
+
### `initcap`
Capitalizes the first character in each word in the input string.
@@ -774,6 +790,22 @@ initcap(str)
[lower](#lower),
[upper](#upper)
+### `instr`
+
+Returns the location where substr first appeared in str (counting from 1).
+If substr does not appear in str, return 0.
+
+```
+instr(str, substr)
+```
+
+#### Arguments
+
+- **str**: String expression to operate on.
+ Can be a constant, column, or function, and any combination of string
operators.
+- **substr**: Substring expression to search for.
+ Can be a constant, column, or function, and any combination of string
operators.
+
### `left`
Returns a specified number of characters from the left side of a string.
diff --git a/searchindex.js b/searchindex.js
index 483afbcc39..381b50c390 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"docnames": ["contributor-guide/architecture",
"contributor-guide/communication", "contributor-guide/index",
"contributor-guide/quarterly_roadmap", "contributor-guide/roadmap",
"contributor-guide/specification/index",
"contributor-guide/specification/invariants",
"contributor-guide/specification/output-field-name-semantic", "index",
"library-user-guide/adding-udfs", "library-user-guide/building-logical-plans",
"library-user-guide/catalogs", "library-user-guide/custom-tab [...]
\ No newline at end of file
+Search.setIndex({"docnames": ["contributor-guide/architecture",
"contributor-guide/communication", "contributor-guide/index",
"contributor-guide/quarterly_roadmap", "contributor-guide/roadmap",
"contributor-guide/specification/index",
"contributor-guide/specification/invariants",
"contributor-guide/specification/output-field-name-semantic", "index",
"library-user-guide/adding-udfs", "library-user-guide/building-logical-plans",
"library-user-guide/catalogs", "library-user-guide/custom-tab [...]
\ No newline at end of file
diff --git a/user-guide/sql/scalar_functions.html
b/user-guide/sql/scalar_functions.html
index 68705865ee..ecd5b66ca0 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -1107,6 +1107,22 @@
</li>
</ul>
</li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#ends-with">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ ends_with
+ </span>
+ </code>
+ </a>
+ <ul class="nav section-nav flex-column">
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id43">
+ Arguments
+ </a>
+ </li>
+ </ul>
+ </li>
<li class="toc-h3 nav-item toc-entry">
<a class="reference internal nav-link" href="#initcap">
<code class="docutils literal notranslate">
@@ -1117,7 +1133,23 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id43">
+ <a class="reference internal nav-link" href="#id44">
+ Arguments
+ </a>
+ </li>
+ </ul>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#instr">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ instr
+ </span>
+ </code>
+ </a>
+ <ul class="nav section-nav flex-column">
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id45">
Arguments
</a>
</li>
@@ -1133,7 +1165,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id44">
+ <a class="reference internal nav-link" href="#id46">
Arguments
</a>
</li>
@@ -1149,12 +1181,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id45">
+ <a class="reference internal nav-link" href="#id47">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id46">
+ <a class="reference internal nav-link" href="#id48">
Aliases
</a>
</li>
@@ -1170,7 +1202,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id47">
+ <a class="reference internal nav-link" href="#id49">
Arguments
</a>
</li>
@@ -1186,7 +1218,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id48">
+ <a class="reference internal nav-link" href="#id50">
Arguments
</a>
</li>
@@ -1202,12 +1234,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id49">
+ <a class="reference internal nav-link" href="#id51">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id50">
+ <a class="reference internal nav-link" href="#id52">
Arguments
</a>
</li>
@@ -1223,7 +1255,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id51">
+ <a class="reference internal nav-link" href="#id53">
Arguments
</a>
</li>
@@ -1239,7 +1271,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id52">
+ <a class="reference internal nav-link" href="#id54">
Arguments
</a>
</li>
@@ -1255,7 +1287,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id53">
+ <a class="reference internal nav-link" href="#id55">
Arguments
</a>
</li>
@@ -1271,7 +1303,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id54">
+ <a class="reference internal nav-link" href="#id56">
Arguments
</a>
</li>
@@ -1287,7 +1319,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id55">
+ <a class="reference internal nav-link" href="#id57">
Arguments
</a>
</li>
@@ -1303,7 +1335,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id56">
+ <a class="reference internal nav-link" href="#id58">
Arguments
</a>
</li>
@@ -1319,7 +1351,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id57">
+ <a class="reference internal nav-link" href="#id59">
Arguments
</a>
</li>
@@ -1335,7 +1367,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id58">
+ <a class="reference internal nav-link" href="#id60">
Arguments
</a>
</li>
@@ -1351,7 +1383,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id59">
+ <a class="reference internal nav-link" href="#id61">
Arguments
</a>
</li>
@@ -1367,7 +1399,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id60">
+ <a class="reference internal nav-link" href="#id62">
Arguments
</a>
</li>
@@ -1383,7 +1415,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id61">
+ <a class="reference internal nav-link" href="#id63">
Arguments
</a>
</li>
@@ -1408,7 +1440,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id62">
+ <a class="reference internal nav-link" href="#id64">
Arguments
</a>
</li>
@@ -1424,7 +1456,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id63">
+ <a class="reference internal nav-link" href="#id65">
Arguments
</a>
</li>
@@ -1440,7 +1472,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id64">
+ <a class="reference internal nav-link" href="#id66">
Arguments
</a>
</li>
@@ -1465,7 +1497,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id65">
+ <a class="reference internal nav-link" href="#id67">
Arguments
</a>
</li>
@@ -1481,7 +1513,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id66">
+ <a class="reference internal nav-link" href="#id68">
Arguments
</a>
</li>
@@ -1497,7 +1529,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id67">
+ <a class="reference internal nav-link" href="#id69">
Arguments
</a>
</li>
@@ -1513,7 +1545,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id68">
+ <a class="reference internal nav-link" href="#id70">
Arguments
</a>
</li>
@@ -1536,7 +1568,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id69">
+ <a class="reference internal nav-link" href="#id71">
Arguments
</a>
</li>
@@ -1552,7 +1584,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id70">
+ <a class="reference internal nav-link" href="#id72">
Arguments
</a>
</li>
@@ -1575,7 +1607,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id71">
+ <a class="reference internal nav-link" href="#id73">
Arguments
</a>
</li>
@@ -1591,7 +1623,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id72">
+ <a class="reference internal nav-link" href="#id74">
Arguments
</a>
</li>
@@ -1623,7 +1655,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id73">
+ <a class="reference internal nav-link" href="#id75">
Aliases
</a>
</li>
@@ -1657,7 +1689,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id74">
+ <a class="reference internal nav-link" href="#id76">
Arguments
</a>
</li>
@@ -1673,12 +1705,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id75">
+ <a class="reference internal nav-link" href="#id77">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id76">
+ <a class="reference internal nav-link" href="#id78">
Aliases
</a>
</li>
@@ -1703,12 +1735,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id77">
+ <a class="reference internal nav-link" href="#id79">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id78">
+ <a class="reference internal nav-link" href="#id80">
Aliases
</a>
</li>
@@ -1733,7 +1765,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id79">
+ <a class="reference internal nav-link" href="#id81">
Arguments
</a>
</li>
@@ -1749,7 +1781,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id80">
+ <a class="reference internal nav-link" href="#id82">
Arguments
</a>
</li>
@@ -1765,7 +1797,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id81">
+ <a class="reference internal nav-link" href="#id83">
Arguments
</a>
</li>
@@ -1781,7 +1813,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id82">
+ <a class="reference internal nav-link" href="#id84">
Arguments
</a>
</li>
@@ -1797,7 +1829,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id83">
+ <a class="reference internal nav-link" href="#id85">
Arguments
</a>
</li>
@@ -1813,7 +1845,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id84">
+ <a class="reference internal nav-link" href="#id86">
Arguments
</a>
</li>
@@ -1829,7 +1861,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id85">
+ <a class="reference internal nav-link" href="#id87">
Arguments
</a>
</li>
@@ -1852,7 +1884,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id86">
+ <a class="reference internal nav-link" href="#id88">
Arguments
</a>
</li>
@@ -1862,7 +1894,7 @@
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id87">
+ <a class="reference internal nav-link" href="#id89">
Aliases
</a>
</li>
@@ -1878,17 +1910,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id88">
+ <a class="reference internal nav-link" href="#id90">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id89">
+ <a class="reference internal nav-link" href="#id91">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id90">
+ <a class="reference internal nav-link" href="#id92">
Aliases
</a>
</li>
@@ -1913,17 +1945,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id91">
+ <a class="reference internal nav-link" href="#id93">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id92">
+ <a class="reference internal nav-link" href="#id94">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id93">
+ <a class="reference internal nav-link" href="#id95">
Aliases
</a>
</li>
@@ -1939,7 +1971,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id94">
+ <a class="reference internal nav-link" href="#id96">
Arguments
</a>
</li>
@@ -1955,7 +1987,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id95">
+ <a class="reference internal nav-link" href="#id97">
Arguments
</a>
</li>
@@ -1971,7 +2003,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id96">
+ <a class="reference internal nav-link" href="#id98">
Arguments
</a>
</li>
@@ -1987,17 +2019,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id97">
+ <a class="reference internal nav-link" href="#id99">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id98">
+ <a class="reference internal nav-link" href="#id100">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id99">
+ <a class="reference internal nav-link" href="#id101">
Aliases
</a>
</li>
@@ -2013,17 +2045,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id100">
+ <a class="reference internal nav-link" href="#id102">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id101">
+ <a class="reference internal nav-link" href="#id103">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id102">
+ <a class="reference internal nav-link" href="#id104">
Aliases
</a>
</li>
@@ -2057,7 +2089,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id103">
+ <a class="reference internal nav-link" href="#id105">
Arguments
</a>
</li>
@@ -2073,7 +2105,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id104">
+ <a class="reference internal nav-link" href="#id106">
Arguments
</a>
</li>
@@ -2107,17 +2139,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id105">
+ <a class="reference internal nav-link" href="#id107">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id106">
+ <a class="reference internal nav-link" href="#id108">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id107">
+ <a class="reference internal nav-link" href="#id109">
Aliases
</a>
</li>
@@ -2133,17 +2165,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id108">
+ <a class="reference internal nav-link" href="#id110">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id109">
+ <a class="reference internal nav-link" href="#id111">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id110">
+ <a class="reference internal nav-link" href="#id112">
Aliases
</a>
</li>
@@ -2159,17 +2191,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id111">
+ <a class="reference internal nav-link" href="#id113">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id112">
+ <a class="reference internal nav-link" href="#id114">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id113">
+ <a class="reference internal nav-link" href="#id115">
Aliases
</a>
</li>
@@ -2185,12 +2217,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id114">
+ <a class="reference internal nav-link" href="#id116">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id115">
+ <a class="reference internal nav-link" href="#id117">
Example
</a>
</li>
@@ -2206,12 +2238,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id116">
+ <a class="reference internal nav-link" href="#id118">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id117">
+ <a class="reference internal nav-link" href="#id119">
Example
</a>
</li>
@@ -2227,17 +2259,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id118">
+ <a class="reference internal nav-link" href="#id120">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id119">
+ <a class="reference internal nav-link" href="#id121">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id120">
+ <a class="reference internal nav-link" href="#id122">
Aliases
</a>
</li>
@@ -2253,17 +2285,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id121">
+ <a class="reference internal nav-link" href="#id123">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id122">
+ <a class="reference internal nav-link" href="#id124">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id123">
+ <a class="reference internal nav-link" href="#id125">
Aliases
</a>
</li>
@@ -2297,12 +2329,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id124">
+ <a class="reference internal nav-link" href="#id126">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id125">
+ <a class="reference internal nav-link" href="#id127">
Example
</a>
</li>
@@ -2318,17 +2350,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id126">
+ <a class="reference internal nav-link" href="#id128">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id127">
+ <a class="reference internal nav-link" href="#id129">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id128">
+ <a class="reference internal nav-link" href="#id130">
Aliases
</a>
</li>
@@ -2344,17 +2376,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id129">
+ <a class="reference internal nav-link" href="#id131">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id130">
+ <a class="reference internal nav-link" href="#id132">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id131">
+ <a class="reference internal nav-link" href="#id133">
Aliases
</a>
</li>
@@ -2370,17 +2402,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id132">
+ <a class="reference internal nav-link" href="#id134">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id133">
+ <a class="reference internal nav-link" href="#id135">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id134">
+ <a class="reference internal nav-link" href="#id136">
Aliases
</a>
</li>
@@ -2396,17 +2428,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id135">
+ <a class="reference internal nav-link" href="#id137">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id136">
+ <a class="reference internal nav-link" href="#id138">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id137">
+ <a class="reference internal nav-link" href="#id139">
Aliases
</a>
</li>
@@ -2422,17 +2454,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id138">
+ <a class="reference internal nav-link" href="#id140">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id139">
+ <a class="reference internal nav-link" href="#id141">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id140">
+ <a class="reference internal nav-link" href="#id142">
Aliases
</a>
</li>
@@ -2448,17 +2480,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id141">
+ <a class="reference internal nav-link" href="#id143">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id142">
+ <a class="reference internal nav-link" href="#id144">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id143">
+ <a class="reference internal nav-link" href="#id145">
Aliases
</a>
</li>
@@ -2474,12 +2506,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id144">
+ <a class="reference internal nav-link" href="#id146">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id145">
+ <a class="reference internal nav-link" href="#id147">
Aliases
</a>
</li>
@@ -2495,17 +2527,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id146">
+ <a class="reference internal nav-link" href="#id148">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id147">
+ <a class="reference internal nav-link" href="#id149">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id148">
+ <a class="reference internal nav-link" href="#id150">
Aliases
</a>
</li>
@@ -2521,17 +2553,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id149">
+ <a class="reference internal nav-link" href="#id151">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id150">
+ <a class="reference internal nav-link" href="#id152">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id151">
+ <a class="reference internal nav-link" href="#id153">
Aliases
</a>
</li>
@@ -2547,17 +2579,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id152">
+ <a class="reference internal nav-link" href="#id154">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id153">
+ <a class="reference internal nav-link" href="#id155">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id154">
+ <a class="reference internal nav-link" href="#id156">
Aliases
</a>
</li>
@@ -2573,12 +2605,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id155">
+ <a class="reference internal nav-link" href="#id157">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id156">
+ <a class="reference internal nav-link" href="#id158">
Example
</a>
</li>
@@ -2594,12 +2626,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id157">
+ <a class="reference internal nav-link" href="#id159">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id158">
+ <a class="reference internal nav-link" href="#id160">
Example
</a>
</li>
@@ -2840,17 +2872,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id159">
+ <a class="reference internal nav-link" href="#id161">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id160">
+ <a class="reference internal nav-link" href="#id162">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id161">
+ <a class="reference internal nav-link" href="#id163">
Aliases
</a>
</li>
@@ -2875,12 +2907,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id162">
+ <a class="reference internal nav-link" href="#id164">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id163">
+ <a class="reference internal nav-link" href="#id165">
Aliases
</a>
</li>
@@ -2905,7 +2937,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id164">
+ <a class="reference internal nav-link" href="#id166">
Arguments
</a>
</li>
@@ -2921,7 +2953,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id165">
+ <a class="reference internal nav-link" href="#id167">
Arguments
</a>
</li>
@@ -2944,7 +2976,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id166">
+ <a class="reference internal nav-link" href="#id168">
Arguments
</a>
</li>
@@ -2967,7 +2999,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id167">
+ <a class="reference internal nav-link" href="#id169">
Arguments
</a>
</li>
@@ -2983,7 +3015,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id168">
+ <a class="reference internal nav-link" href="#id170">
Arguments
</a>
</li>
@@ -2999,7 +3031,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id169">
+ <a class="reference internal nav-link" href="#id171">
Arguments
</a>
</li>
@@ -3015,7 +3047,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id170">
+ <a class="reference internal nav-link" href="#id172">
Arguments
</a>
</li>
@@ -3031,7 +3063,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id171">
+ <a class="reference internal nav-link" href="#id173">
Arguments
</a>
</li>
@@ -3047,7 +3079,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id172">
+ <a class="reference internal nav-link" href="#id174">
Arguments
</a>
</li>
@@ -3070,12 +3102,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id173">
+ <a class="reference internal nav-link" href="#id175">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id174">
+ <a class="reference internal nav-link" href="#id176">
Example
</a>
</li>
@@ -3091,12 +3123,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id175">
+ <a class="reference internal nav-link" href="#id177">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id176">
+ <a class="reference internal nav-link" href="#id178">
Example
</a>
</li>
@@ -3787,7 +3819,9 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
<li><p><a class="reference internal" href="#concat">concat</a></p></li>
<li><p><a class="reference internal" href="#concat-ws">concat_ws</a></p></li>
<li><p><a class="reference internal" href="#chr">chr</a></p></li>
+<li><p><a class="reference internal" href="#ends-with">ends_with</a></p></li>
<li><p><a class="reference internal" href="#initcap">initcap</a></p></li>
+<li><p><a class="reference internal" href="#instr">instr</a></p></li>
<li><p><a class="reference internal" href="#left">left</a></p></li>
<li><p><a class="reference internal" href="#length">length</a></p></li>
<li><p><a class="reference internal" href="#lower">lower</a></p></li>
@@ -3930,6 +3964,21 @@ string operators.</p></li>
<a class="reference internal" href="#ascii">ascii</a></p>
</section>
</section>
+<section id="ends-with">
+<h3><code class="docutils literal notranslate"><span
class="pre">ends_with</span></code><a class="headerlink" href="#ends-with"
title="Link to this heading">¶</a></h3>
+<p>Tests if a string ends with a substring.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">ends_with</span><span
class="p">(</span><span class="nb">str</span><span class="p">,</span> <span
class="n">substr</span><span class="p">)</span>
+</pre></div>
+</div>
+<section id="id43">
+<h4>Arguments<a class="headerlink" href="#id43" title="Link to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p><strong>str</strong>: String expression to test.
+Can be a constant, column, or function, and any combination of string
operators.</p></li>
+<li><p><strong>substr</strong>: Substring to test for.</p></li>
+</ul>
+</section>
+</section>
<section id="initcap">
<h3><code class="docutils literal notranslate"><span
class="pre">initcap</span></code><a class="headerlink" href="#initcap"
title="Link to this heading">¶</a></h3>
<p>Capitalizes the first character in each word in the input string.
@@ -3937,8 +3986,8 @@ Words are delimited by non-alphanumeric characters.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">initcap</span><span
class="p">(</span><span class="nb">str</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id43">
-<h4>Arguments<a class="headerlink" href="#id43" title="Link to this
heading">¶</a></h4>
+<section id="id44">
+<h4>Arguments<a class="headerlink" href="#id44" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -3948,14 +3997,31 @@ Can be a constant, column, or function, and any
combination of string operators.
<a class="reference internal" href="#upper">upper</a></p>
</section>
</section>
+<section id="instr">
+<h3><code class="docutils literal notranslate"><span
class="pre">instr</span></code><a class="headerlink" href="#instr" title="Link
to this heading">¶</a></h3>
+<p>Returns the location where substr first appeared in str (counting from 1).
+If substr does not appear in str, return 0.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">instr</span><span
class="p">(</span><span class="nb">str</span><span class="p">,</span> <span
class="n">substr</span><span class="p">)</span>
+</pre></div>
+</div>
+<section id="id45">
+<h4>Arguments<a class="headerlink" href="#id45" title="Link to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p><strong>str</strong>: String expression to operate on.
+Can be a constant, column, or function, and any combination of string
operators.</p></li>
+<li><p><strong>substr</strong>: Substring expression to search for.
+Can be a constant, column, or function, and any combination of string
operators.</p></li>
+</ul>
+</section>
+</section>
<section id="left">
<h3><code class="docutils literal notranslate"><span
class="pre">left</span></code><a class="headerlink" href="#left" title="Link to
this heading">¶</a></h3>
<p>Returns a specified number of characters from the left side of a string.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">left</span><span
class="p">(</span><span class="nb">str</span><span class="p">,</span> <span
class="n">n</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id44">
-<h4>Arguments<a class="headerlink" href="#id44" title="Link to this
heading">¶</a></h4>
+<section id="id46">
+<h4>Arguments<a class="headerlink" href="#id46" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -3971,15 +4037,15 @@ Can be a constant, column, or function, and any
combination of string operators.
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">length</span><span
class="p">(</span><span class="nb">str</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id45">
-<h4>Arguments<a class="headerlink" href="#id45" title="Link to this
heading">¶</a></h4>
+<section id="id47">
+<h4>Arguments<a class="headerlink" href="#id47" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
</ul>
</section>
-<section id="id46">
-<h4>Aliases<a class="headerlink" href="#id46" title="Link to this
heading">¶</a></h4>
+<section id="id48">
+<h4>Aliases<a class="headerlink" href="#id48" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>char_length</p></li>
<li><p>character_length</p></li>
@@ -3995,8 +4061,8 @@ Can be a constant, column, or function, and any
combination of string operators.
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">lower</span><span
class="p">(</span><span class="nb">str</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id47">
-<h4>Arguments<a class="headerlink" href="#id47" title="Link to this
heading">¶</a></h4>
+<section id="id49">
+<h4>Arguments<a class="headerlink" href="#id49" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -4012,8 +4078,8 @@ Can be a constant, column, or function, and any
combination of string operators.
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">lpad</span><span
class="p">(</span><span class="nb">str</span><span class="p">,</span> <span
class="n">n</span><span class="p">[,</span> <span
class="n">padding_str</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id48">
-<h4>Arguments<a class="headerlink" href="#id48" title="Link to this
heading">¶</a></h4>
+<section id="id50">
+<h4>Arguments<a class="headerlink" href="#id50" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -4032,8 +4098,8 @@ Can be a constant, column, or function, and any
combination of string operators.
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">ltrim</span><span
class="p">(</span><span class="nb">str</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id49">
-<h4>Arguments<a class="headerlink" href="#id49" title="Link to this
heading">¶</a></h4>
+<section id="id51">
+<h4>Arguments<a class="headerlink" href="#id51" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -4043,8 +4109,8 @@ Can be a constant, column, or function, and any
combination of string operators.
<a class="reference internal" href="#rtrim">rtrim</a>,
<a class="reference internal" href="#trim">trim</a></p>
</section>
-<section id="id50">
-<h4>Arguments<a class="headerlink" href="#id50" title="Link to this
heading">¶</a></h4>
+<section id="id52">
+<h4>Arguments<a class="headerlink" href="#id52" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -4057,8 +4123,8 @@ Can be a constant, column, or function, and any
combination of string operators.
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">octet_length</span><span
class="p">(</span><span class="nb">str</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id51">
-<h4>Arguments<a class="headerlink" href="#id51" title="Link to this
heading">¶</a></h4>
+<section id="id53">
+<h4>Arguments<a class="headerlink" href="#id53" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -4074,8 +4140,8 @@ Can be a constant, column, or function, and any
combination of string operators.
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">repeat</span><span
class="p">(</span><span class="nb">str</span><span class="p">,</span> <span
class="n">n</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id52">
-<h4>Arguments<a class="headerlink" href="#id52" title="Link to this
heading">¶</a></h4>
+<section id="id54">
+<h4>Arguments<a class="headerlink" href="#id54" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to repeat.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -4089,8 +4155,8 @@ Can be a constant, column, or function, and any
combination of string operators.
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">replace</span><span
class="p">(</span><span class="nb">str</span><span class="p">,</span> <span
class="n">substr</span><span class="p">,</span> <span
class="n">replacement</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id53">
-<h4>Arguments<a class="headerlink" href="#id53" title="Link to this
heading">¶</a></h4>
+<section id="id55">
+<h4>Arguments<a class="headerlink" href="#id55" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to repeat.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -4107,8 +4173,8 @@ Can be a constant, column, or function, and any
combination of string operators.
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">reverse</span><span
class="p">(</span><span class="nb">str</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id54">
-<h4>Arguments<a class="headerlink" href="#id54" title="Link to this
heading">¶</a></h4>
+<section id="id56">
+<h4>Arguments<a class="headerlink" href="#id56" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to repeat.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -4121,8 +4187,8 @@ Can be a constant, column, or function, and any
combination of string operators.
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">right</span><span
class="p">(</span><span class="nb">str</span><span class="p">,</span> <span
class="n">n</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id55">
-<h4>Arguments<a class="headerlink" href="#id55" title="Link to this
heading">¶</a></h4>
+<section id="id57">
+<h4>Arguments<a class="headerlink" href="#id57" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -4138,8 +4204,8 @@ Can be a constant, column, or function, and any
combination of string operators.
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">rpad</span><span
class="p">(</span><span class="nb">str</span><span class="p">,</span> <span
class="n">n</span><span class="p">[,</span> <span
class="n">padding_str</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id56">
-<h4>Arguments<a class="headerlink" href="#id56" title="Link to this
heading">¶</a></h4>
+<section id="id58">
+<h4>Arguments<a class="headerlink" href="#id58" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -4158,8 +4224,8 @@ Can be a constant, column, or function, and any
combination of string operators.
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">rtrim</span><span
class="p">(</span><span class="nb">str</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id57">
-<h4>Arguments<a class="headerlink" href="#id57" title="Link to this
heading">¶</a></h4>
+<section id="id59">
+<h4>Arguments<a class="headerlink" href="#id59" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -4177,8 +4243,8 @@ specified position.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">split_part</span><span
class="p">(</span><span class="nb">str</span><span class="p">,</span> <span
class="n">delimiter</span><span class="p">,</span> <span
class="n">pos</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id58">
-<h4>Arguments<a class="headerlink" href="#id58" title="Link to this
heading">¶</a></h4>
+<section id="id60">
+<h4>Arguments<a class="headerlink" href="#id60" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to spit.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -4193,8 +4259,8 @@ Can be a constant, column, or function, and any
combination of string operators.
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">starts_with</span><span
class="p">(</span><span class="nb">str</span><span class="p">,</span> <span
class="n">substr</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id59">
-<h4>Arguments<a class="headerlink" href="#id59" title="Link to this
heading">¶</a></h4>
+<section id="id61">
+<h4>Arguments<a class="headerlink" href="#id61" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to test.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -4210,8 +4276,8 @@ If the substring does not exist in the string, the
function returns 0.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">strpos</span><span
class="p">(</span><span class="nb">str</span><span class="p">,</span> <span
class="n">substr</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id60">
-<h4>Arguments<a class="headerlink" href="#id60" title="Link to this
heading">¶</a></h4>
+<section id="id62">
+<h4>Arguments<a class="headerlink" href="#id62" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -4227,8 +4293,8 @@ starting position in a string.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">substr</span><span
class="p">(</span><span class="nb">str</span><span class="p">,</span> <span
class="n">start_pos</span><span class="p">[,</span> <span
class="n">length</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id61">
-<h4>Arguments<a class="headerlink" href="#id61" title="Link to this
heading">¶</a></h4>
+<section id="id63">
+<h4>Arguments<a class="headerlink" href="#id63" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -4259,8 +4325,8 @@ characters at the same position in the
<strong>chars</strong> string.</p></li>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">to_hex</span><span
class="p">(</span><span class="nb">int</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id62">
-<h4>Arguments<a class="headerlink" href="#id62" title="Link to this
heading">¶</a></h4>
+<section id="id64">
+<h4>Arguments<a class="headerlink" href="#id64" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>int</strong>: Integer expression to convert.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -4273,8 +4339,8 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">trim</span><span
class="p">(</span><span class="nb">str</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id63">
-<h4>Arguments<a class="headerlink" href="#id63" title="Link to this
heading">¶</a></h4>
+<section id="id65">
+<h4>Arguments<a class="headerlink" href="#id65" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -4291,8 +4357,8 @@ Can be a constant, column, or function, and any
combination of string operators.
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">upper</span><span
class="p">(</span><span class="nb">str</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id64">
-<h4>Arguments<a class="headerlink" href="#id64" title="Link to this
heading">¶</a></h4>
+<section id="id66">
+<h4>Arguments<a class="headerlink" href="#id66" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -4316,8 +4382,8 @@ For example, <code class="docutils literal
notranslate"><span class="pre">overla
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">overlay</span><span
class="p">(</span><span class="nb">str</span> <span class="n">PLACING</span>
<span class="n">substr</span> <span class="n">FROM</span> <span
class="n">pos</span> <span class="p">[</span><span class="n">FOR</span> <span
class="n">count</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id65">
-<h4>Arguments<a class="headerlink" href="#id65" title="Link to this
heading">¶</a></h4>
+<section id="id67">
+<h4>Arguments<a class="headerlink" href="#id67" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to operate on.</p></li>
<li><p><strong>substr</strong>: the string to replace part of str.</p></li>
@@ -4333,8 +4399,8 @@ For example, <code class="docutils literal
notranslate"><span class="pre">levens
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">levenshtein</span><span
class="p">(</span><span class="n">str1</span><span class="p">,</span> <span
class="n">str2</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id66">
-<h4>Arguments<a class="headerlink" href="#id66" title="Link to this
heading">¶</a></h4>
+<section id="id68">
+<h4>Arguments<a class="headerlink" href="#id68" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str1</strong>: String expression to compute Levenshtein
distance with str2.</p></li>
<li><p><strong>str2</strong>: String expression to compute Levenshtein
distance with str1.</p></li>
@@ -4350,8 +4416,8 @@ For example, <code class="docutils literal
notranslate"><span class="pre">substr
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">substr_index</span><span
class="p">(</span><span class="nb">str</span><span class="p">,</span> <span
class="n">delim</span><span class="p">,</span> <span
class="n">count</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id67">
-<h4>Arguments<a class="headerlink" href="#id67" title="Link to this
heading">¶</a></h4>
+<section id="id69">
+<h4>Arguments<a class="headerlink" href="#id69" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to operate on.</p></li>
<li><p><strong>delim</strong>: the string to find in str to split str.</p></li>
@@ -4366,8 +4432,8 @@ For example, <code class="docutils literal
notranslate"><span class="pre">find_i
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">find_in_set</span><span
class="p">(</span><span class="nb">str</span><span class="p">,</span> <span
class="n">strlist</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id68">
-<h4>Arguments<a class="headerlink" href="#id68" title="Link to this
heading">¶</a></h4>
+<section id="id70">
+<h4>Arguments<a class="headerlink" href="#id70" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to find in strlist.</p></li>
<li><p><strong>strlist</strong>: A string list is a string composed of
substrings separated by , characters.</p></li>
@@ -4387,8 +4453,8 @@ For example, <code class="docutils literal
notranslate"><span class="pre">find_i
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">encode</span><span
class="p">(</span><span class="n">expression</span><span class="p">,</span>
<span class="nb">format</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id69">
-<h4>Arguments<a class="headerlink" href="#id69" title="Link to this
heading">¶</a></h4>
+<section id="id71">
+<h4>Arguments<a class="headerlink" href="#id71" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression containing string or binary
data</p></li>
<li><p><strong>format</strong>: Supported formats are: <code class="docutils
literal notranslate"><span class="pre">base64</span></code>, <code
class="docutils literal notranslate"><span
class="pre">hex</span></code></p></li>
@@ -4403,8 +4469,8 @@ For example, <code class="docutils literal
notranslate"><span class="pre">find_i
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">decode</span><span
class="p">(</span><span class="n">expression</span><span class="p">,</span>
<span class="nb">format</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id70">
-<h4>Arguments<a class="headerlink" href="#id70" title="Link to this
heading">¶</a></h4>
+<section id="id72">
+<h4>Arguments<a class="headerlink" href="#id72" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression containing encoded string
data</p></li>
<li><p><strong>format</strong>: Same arguments as <a class="reference
internal" href="#encode">encode</a></p></li>
@@ -4428,8 +4494,8 @@ supports the following regular expression functions:</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">regexp_match</span><span
class="p">(</span><span class="nb">str</span><span class="p">,</span> <span
class="n">regexp</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id71">
-<h4>Arguments<a class="headerlink" href="#id71" title="Link to this
heading">¶</a></h4>
+<section id="id73">
+<h4>Arguments<a class="headerlink" href="#id73" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -4444,8 +4510,8 @@ Can be a constant, column, or function.</p></li>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">regexp_replace</span><span
class="p">(</span><span class="nb">str</span><span class="p">,</span> <span
class="n">regexp</span><span class="p">,</span> <span
class="n">replacement</span><span class="p">,</span> <span
class="n">flags</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id72">
-<h4>Arguments<a class="headerlink" href="#id72" title="Link to this
heading">¶</a></h4>
+<section id="id74">
+<h4>Arguments<a class="headerlink" href="#id74" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -4501,8 +4567,8 @@ no matter when in the query plan the function
executes.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">current_date</span><span
class="p">()</span>
</pre></div>
</div>
-<section id="id73">
-<h4>Aliases<a class="headerlink" href="#id73" title="Link to this
heading">¶</a></h4>
+<section id="id75">
+<h4>Aliases<a class="headerlink" href="#id75" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>today</p></li>
</ul>
@@ -4532,8 +4598,8 @@ minute bin it is in: <code class="docutils literal
notranslate"><span class="pre
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">date_bin</span><span
class="p">(</span><span class="n">interval</span><span class="p">,</span> <span
class="n">expression</span><span class="p">,</span> <span
class="n">origin</span><span class="o">-</span><span
class="n">timestamp</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id74">
-<h4>Arguments<a class="headerlink" href="#id74" title="Link to this
heading">¶</a></h4>
+<section id="id76">
+<h4>Arguments<a class="headerlink" href="#id76" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>interval</strong>: Bin interval.</p></li>
<li><p><strong>expression</strong>: Time expression to operate on.
@@ -4563,8 +4629,8 @@ defaults <code class="docutils literal notranslate"><span
class="pre">1970-01-01
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">date_trunc</span><span
class="p">(</span><span class="n">precision</span><span class="p">,</span>
<span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id75">
-<h4>Arguments<a class="headerlink" href="#id75" title="Link to this
heading">¶</a></h4>
+<section id="id77">
+<h4>Arguments<a class="headerlink" href="#id77" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>precision</strong>: Time precision to truncate to.
The following precisions are supported:</p>
@@ -4583,8 +4649,8 @@ The following precisions are supported:</p>
Can be a constant, column, or function.</p></li>
</ul>
</section>
-<section id="id76">
-<h4>Aliases<a class="headerlink" href="#id76" title="Link to this
heading">¶</a></h4>
+<section id="id78">
+<h4>Aliases<a class="headerlink" href="#id78" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>datetrunc</p></li>
</ul>
@@ -4600,8 +4666,8 @@ Can be a constant, column, or function.</p></li>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">date_part</span><span
class="p">(</span><span class="n">part</span><span class="p">,</span> <span
class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id77">
-<h4>Arguments<a class="headerlink" href="#id77" title="Link to this
heading">¶</a></h4>
+<section id="id79">
+<h4>Arguments<a class="headerlink" href="#id79" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>part</strong>: Part of the date to return.
The following date parts are supported:</p>
@@ -4626,8 +4692,8 @@ The following date parts are supported:</p>
Can be a constant, column, or function.</p></li>
</ul>
</section>
-<section id="id78">
-<h4>Aliases<a class="headerlink" href="#id78" title="Link to this
heading">¶</a></h4>
+<section id="id80">
+<h4>Aliases<a class="headerlink" href="#id80" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>datepart</p></li>
</ul>
@@ -4644,8 +4710,8 @@ Similar to <code class="docutils literal
notranslate"><span class="pre">date_par
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">extract</span><span
class="p">(</span><span class="n">field</span> <span class="n">FROM</span>
<span class="n">source</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id79">
-<h4>Arguments<a class="headerlink" href="#id79" title="Link to this
heading">¶</a></h4>
+<section id="id81">
+<h4>Arguments<a class="headerlink" href="#id81" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>field</strong>: Part or field of the date to return.
The following date fields are supported:</p>
@@ -4684,8 +4750,8 @@ for the input outside of supported bounds.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">to_timestamp</span><span
class="p">(</span><span class="n">expression</span><span class="p">[,</span>
<span class="o">...</span><span class="p">,</span> <span
class="n">format_n</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id80">
-<h4>Arguments<a class="headerlink" href="#id80" title="Link to this
heading">¶</a></h4>
+<section id="id82">
+<h4>Arguments<a class="headerlink" href="#id82" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -4705,8 +4771,8 @@ Returns the corresponding timestamp.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span
class="n">to_timestamp_millis</span><span class="p">(</span><span
class="n">expression</span><span class="p">[,</span> <span
class="o">...</span><span class="p">,</span> <span
class="n">format_n</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id81">
-<h4>Arguments<a class="headerlink" href="#id81" title="Link to this
heading">¶</a></h4>
+<section id="id83">
+<h4>Arguments<a class="headerlink" href="#id83" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -4726,8 +4792,8 @@ Returns the corresponding timestamp.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span
class="n">to_timestamp_micros</span><span class="p">(</span><span
class="n">expression</span><span class="p">[,</span> <span
class="o">...</span><span class="p">,</span> <span
class="n">format_n</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id82">
-<h4>Arguments<a class="headerlink" href="#id82" title="Link to this
heading">¶</a></h4>
+<section id="id84">
+<h4>Arguments<a class="headerlink" href="#id84" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -4747,8 +4813,8 @@ Returns the corresponding timestamp.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span
class="n">to_timestamp_nanos</span><span class="p">(</span><span
class="n">expression</span><span class="p">[,</span> <span
class="o">...</span><span class="p">,</span> <span
class="n">format_n</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id83">
-<h4>Arguments<a class="headerlink" href="#id83" title="Link to this
heading">¶</a></h4>
+<section id="id85">
+<h4>Arguments<a class="headerlink" href="#id85" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -4768,8 +4834,8 @@ Returns the corresponding timestamp.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span
class="n">to_timestamp_seconds</span><span class="p">(</span><span
class="n">expression</span><span class="p">[,</span> <span
class="o">...</span><span class="p">,</span> <span
class="n">format_n</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id84">
-<h4>Arguments<a class="headerlink" href="#id84" title="Link to this
heading">¶</a></h4>
+<section id="id86">
+<h4>Arguments<a class="headerlink" href="#id86" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -4787,8 +4853,8 @@ return the corresponding timestamp.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">from_unixtime</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id85">
-<h4>Arguments<a class="headerlink" href="#id85" title="Link to this
heading">¶</a></h4>
+<section id="id87">
+<h4>Arguments<a class="headerlink" href="#id87" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -4867,8 +4933,8 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_append</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">element</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id86">
-<h4>Arguments<a class="headerlink" href="#id86" title="Link to this
heading">¶</a></h4>
+<section id="id88">
+<h4>Arguments<a class="headerlink" href="#id88" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -4886,8 +4952,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id87">
-<h4>Aliases<a class="headerlink" href="#id87" title="Link to this
heading">¶</a></h4>
+<section id="id89">
+<h4>Aliases<a class="headerlink" href="#id89" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>array_push_back</p></li>
<li><p>list_append</p></li>
@@ -4901,8 +4967,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_sort</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">desc</span><span class="p">,</span> <span
class="n">nulls_first</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id88">
-<h4>Arguments<a class="headerlink" href="#id88" title="Link to this
heading">¶</a></h4>
+<section id="id90">
+<h4>Arguments<a class="headerlink" href="#id90" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -4910,8 +4976,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<li><p><strong>nulls_first</strong>: Whether to sort nulls first(<code
class="docutils literal notranslate"><span class="pre">NULLS</span> <span
class="pre">FIRST</span></code> or <code class="docutils literal
notranslate"><span class="pre">NULLS</span> <span
class="pre">LAST</span></code>).</p></li>
</ul>
</section>
-<section id="id89">
-<h4>Example<a class="headerlink" href="#id89" title="Link to this
heading">¶</a></h4>
+<section id="id91">
+<h4>Example<a class="headerlink" href="#id91" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_sort([3, 1, 2]);
+-----------------------------+
| array_sort(List([3,1,2])) |
@@ -4921,8 +4987,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id90">
-<h4>Aliases<a class="headerlink" href="#id90" title="Link to this
heading">¶</a></h4>
+<section id="id92">
+<h4>Aliases<a class="headerlink" href="#id92" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_sort</p></li>
</ul>
@@ -4938,16 +5004,16 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_concat</span><span
class="p">(</span><span class="n">array</span><span class="p">[,</span> <span
class="o">...</span><span class="p">,</span> <span
class="n">array_n</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id91">
-<h4>Arguments<a class="headerlink" href="#id91" title="Link to this
heading">¶</a></h4>
+<section id="id93">
+<h4>Arguments<a class="headerlink" href="#id93" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression to concatenate.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
<li><p><strong>array_n</strong>: Subsequent array column or literal array to
concatenate.</p></li>
</ul>
</section>
-<section id="id92">
-<h4>Example<a class="headerlink" href="#id92" title="Link to this
heading">¶</a></h4>
+<section id="id94">
+<h4>Example<a class="headerlink" href="#id94" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_concat([1, 2], [3, 4], [5,
6]);
+---------------------------------------------------+
| array_concat(List([1,2]),List([3,4]),List([5,6])) |
@@ -4957,8 +5023,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id93">
-<h4>Aliases<a class="headerlink" href="#id93" title="Link to this
heading">¶</a></h4>
+<section id="id95">
+<h4>Aliases<a class="headerlink" href="#id95" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>array_cat</p></li>
<li><p>list_cat</p></li>
@@ -4972,8 +5038,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_has</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">element</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id94">
-<h4>Arguments<a class="headerlink" href="#id94" title="Link to this
heading">¶</a></h4>
+<section id="id96">
+<h4>Arguments<a class="headerlink" href="#id96" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -4988,8 +5054,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_has_all</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">sub</span><span class="o">-</span><span class="n">array</span><span
class="p">)</span>
</pre></div>
</div>
-<section id="id95">
-<h4>Arguments<a class="headerlink" href="#id95" title="Link to this
heading">¶</a></h4>
+<section id="id97">
+<h4>Arguments<a class="headerlink" href="#id97" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -5004,8 +5070,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_has_any</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">sub</span><span class="o">-</span><span class="n">array</span><span
class="p">)</span>
</pre></div>
</div>
-<section id="id96">
-<h4>Arguments<a class="headerlink" href="#id96" title="Link to this
heading">¶</a></h4>
+<section id="id98">
+<h4>Arguments<a class="headerlink" href="#id98" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -5020,15 +5086,15 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_dims</span><span
class="p">(</span><span class="n">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id97">
-<h4>Arguments<a class="headerlink" href="#id97" title="Link to this
heading">¶</a></h4>
+<section id="id99">
+<h4>Arguments<a class="headerlink" href="#id99" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
</ul>
</section>
-<section id="id98">
-<h4>Example<a class="headerlink" href="#id98" title="Link to this
heading">¶</a></h4>
+<section id="id100">
+<h4>Example<a class="headerlink" href="#id100" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_dims([[1, 2, 3], [4, 5, 6]]);
+---------------------------------+
| array_dims(List([1,2,3,4,5,6])) |
@@ -5038,8 +5104,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id99">
-<h4>Aliases<a class="headerlink" href="#id99" title="Link to this
heading">¶</a></h4>
+<section id="id101">
+<h4>Aliases<a class="headerlink" href="#id101" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_dims</p></li>
</ul>
@@ -5051,16 +5117,16 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_element</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">index</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id100">
-<h4>Arguments<a class="headerlink" href="#id100" title="Link to this
heading">¶</a></h4>
+<section id="id102">
+<h4>Arguments<a class="headerlink" href="#id102" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
<li><p><strong>index</strong>: Index to extract the element from the
array.</p></li>
</ul>
</section>
-<section id="id101">
-<h4>Example<a class="headerlink" href="#id101" title="Link to this
heading">¶</a></h4>
+<section id="id103">
+<h4>Example<a class="headerlink" href="#id103" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_element([1, 2, 3, 4], 3);
+-----------------------------------------+
| array_element(List([1,2,3,4]),Int64(3)) |
@@ -5070,8 +5136,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id102">
-<h4>Aliases<a class="headerlink" href="#id102" title="Link to this
heading">¶</a></h4>
+<section id="id104">
+<h4>Aliases<a class="headerlink" href="#id104" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>array_extract</p></li>
<li><p>list_element</p></li>
@@ -5093,8 +5159,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_fill</span><span
class="p">(</span><span class="n">element</span><span class="p">,</span> <span
class="n">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id103">
-<h4>Arguments<a class="headerlink" href="#id103" title="Link to this
heading">¶</a></h4>
+<section id="id105">
+<h4>Arguments<a class="headerlink" href="#id105" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -5110,8 +5176,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<li><p>Does not change arrays that are already flat</p></li>
</ul>
<p>The flattened array contains all the elements from all source arrays.</p>
-<section id="id104">
-<h4>Arguments<a class="headerlink" href="#id104" title="Link to this
heading">¶</a></h4>
+<section id="id106">
+<h4>Arguments<a class="headerlink" href="#id106" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -5135,16 +5201,16 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_length</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">dimension</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id105">
-<h4>Arguments<a class="headerlink" href="#id105" title="Link to this
heading">¶</a></h4>
+<section id="id107">
+<h4>Arguments<a class="headerlink" href="#id107" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
<li><p><strong>dimension</strong>: Array dimension.</p></li>
</ul>
</section>
-<section id="id106">
-<h4>Example<a class="headerlink" href="#id106" title="Link to this
heading">¶</a></h4>
+<section id="id108">
+<h4>Example<a class="headerlink" href="#id108" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_length([1, 2, 3, 4, 5]);
+---------------------------------+
| array_length(List([1,2,3,4,5])) |
@@ -5154,8 +5220,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id107">
-<h4>Aliases<a class="headerlink" href="#id107" title="Link to this
heading">¶</a></h4>
+<section id="id109">
+<h4>Aliases<a class="headerlink" href="#id109" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_length</p></li>
</ul>
@@ -5167,15 +5233,15 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_ndims</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">element</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id108">
-<h4>Arguments<a class="headerlink" href="#id108" title="Link to this
heading">¶</a></h4>
+<section id="id110">
+<h4>Arguments<a class="headerlink" href="#id110" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
</ul>
</section>
-<section id="id109">
-<h4>Example<a class="headerlink" href="#id109" title="Link to this
heading">¶</a></h4>
+<section id="id111">
+<h4>Example<a class="headerlink" href="#id111" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_ndims([[1, 2, 3], [4, 5,
6]]);
+----------------------------------+
| array_ndims(List([1,2,3,4,5,6])) |
@@ -5185,8 +5251,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id110">
-<h4>Aliases<a class="headerlink" href="#id110" title="Link to this
heading">¶</a></h4>
+<section id="id112">
+<h4>Aliases<a class="headerlink" href="#id112" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_ndims</p></li>
</ul>
@@ -5198,16 +5264,16 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_prepend</span><span
class="p">(</span><span class="n">element</span><span class="p">,</span> <span
class="n">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id111">
-<h4>Arguments<a class="headerlink" href="#id111" title="Link to this
heading">¶</a></h4>
+<section id="id113">
+<h4>Arguments<a class="headerlink" href="#id113" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>element</strong>: Element to prepend to the array.</p></li>
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
</ul>
</section>
-<section id="id112">
-<h4>Example<a class="headerlink" href="#id112" title="Link to this
heading">¶</a></h4>
+<section id="id114">
+<h4>Example<a class="headerlink" href="#id114" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_prepend(1, [2, 3, 4]);
+---------------------------------------+
| array_prepend(Int64(1),List([2,3,4])) |
@@ -5217,8 +5283,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id113">
-<h4>Aliases<a class="headerlink" href="#id113" title="Link to this
heading">¶</a></h4>
+<section id="id115">
+<h4>Aliases<a class="headerlink" href="#id115" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>array_push_front</p></li>
<li><p>list_prepend</p></li>
@@ -5232,15 +5298,15 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_pop_front</span><span
class="p">(</span><span class="n">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id114">
-<h4>Arguments<a class="headerlink" href="#id114" title="Link to this
heading">¶</a></h4>
+<section id="id116">
+<h4>Arguments<a class="headerlink" href="#id116" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
</ul>
</section>
-<section id="id115">
-<h4>Example<a class="headerlink" href="#id115" title="Link to this
heading">¶</a></h4>
+<section id="id117">
+<h4>Example<a class="headerlink" href="#id117" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_pop_front([1, 2, 3]);
+-------------------------------+
| array_pop_front(List([1,2,3])) |
@@ -5257,15 +5323,15 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_pop_back</span><span
class="p">(</span><span class="n">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id116">
-<h4>Arguments<a class="headerlink" href="#id116" title="Link to this
heading">¶</a></h4>
+<section id="id118">
+<h4>Arguments<a class="headerlink" href="#id118" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
</ul>
</section>
-<section id="id117">
-<h4>Example<a class="headerlink" href="#id117" title="Link to this
heading">¶</a></h4>
+<section id="id119">
+<h4>Example<a class="headerlink" href="#id119" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_pop_back([1, 2, 3]);
+-------------------------------+
| array_pop_back(List([1,2,3])) |
@@ -5283,8 +5349,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<span class="n">array_position</span><span class="p">(</span><span
class="n">array</span><span class="p">,</span> <span
class="n">element</span><span class="p">,</span> <span
class="n">index</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id118">
-<h4>Arguments<a class="headerlink" href="#id118" title="Link to this
heading">¶</a></h4>
+<section id="id120">
+<h4>Arguments<a class="headerlink" href="#id120" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -5292,8 +5358,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<li><p><strong>index</strong>: Index at which to start searching.</p></li>
</ul>
</section>
-<section id="id119">
-<h4>Example<a class="headerlink" href="#id119" title="Link to this
heading">¶</a></h4>
+<section id="id121">
+<h4>Example<a class="headerlink" href="#id121" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_position([1, 2, 2, 3, 1, 4],
2);
+----------------------------------------------+
| array_position(List([1,2,2,3,1,4]),Int64(2)) |
@@ -5303,8 +5369,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id120">
-<h4>Aliases<a class="headerlink" href="#id120" title="Link to this
heading">¶</a></h4>
+<section id="id122">
+<h4>Aliases<a class="headerlink" href="#id122" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>array_indexof</p></li>
<li><p>list_indexof</p></li>
@@ -5318,16 +5384,16 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_positions</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">element</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id121">
-<h4>Arguments<a class="headerlink" href="#id121" title="Link to this
heading">¶</a></h4>
+<section id="id123">
+<h4>Arguments<a class="headerlink" href="#id123" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
<li><p><strong>element</strong>: Element to search for positions in the
array.</p></li>
</ul>
</section>
-<section id="id122">
-<h4>Example<a class="headerlink" href="#id122" title="Link to this
heading">¶</a></h4>
+<section id="id124">
+<h4>Example<a class="headerlink" href="#id124" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_positions([1, 2, 2, 3, 1,
4], 2);
+-----------------------------------------------+
| array_positions(List([1,2,2,3,1,4]),Int64(2)) |
@@ -5337,8 +5403,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id123">
-<h4>Aliases<a class="headerlink" href="#id123" title="Link to this
heading">¶</a></h4>
+<section id="id125">
+<h4>Aliases<a class="headerlink" href="#id125" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_positions</p></li>
</ul>
@@ -5358,16 +5424,16 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_repeat</span><span
class="p">(</span><span class="n">element</span><span class="p">,</span> <span
class="n">count</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id124">
-<h4>Arguments<a class="headerlink" href="#id124" title="Link to this
heading">¶</a></h4>
+<section id="id126">
+<h4>Arguments<a class="headerlink" href="#id126" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>element</strong>: Element expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
<li><p><strong>count</strong>: Value of how many times to repeat the
element.</p></li>
</ul>
</section>
-<section id="id125">
-<h4>Example<a class="headerlink" href="#id125" title="Link to this
heading">¶</a></h4>
+<section id="id127">
+<h4>Example<a class="headerlink" href="#id127" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_repeat(1, 3);
+---------------------------------+
| array_repeat(Int64(1),Int64(3)) |
@@ -5392,16 +5458,16 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_remove</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">element</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id126">
-<h4>Arguments<a class="headerlink" href="#id126" title="Link to this
heading">¶</a></h4>
+<section id="id128">
+<h4>Arguments<a class="headerlink" href="#id128" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
<li><p><strong>element</strong>: Element to be removed from the array.</p></li>
</ul>
</section>
-<section id="id127">
-<h4>Example<a class="headerlink" href="#id127" title="Link to this
heading">¶</a></h4>
+<section id="id129">
+<h4>Example<a class="headerlink" href="#id129" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_remove([1, 2, 2, 3, 2, 1,
4], 2);
+----------------------------------------------+
| array_remove(List([1,2,2,3,2,1,4]),Int64(2)) |
@@ -5411,8 +5477,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id128">
-<h4>Aliases<a class="headerlink" href="#id128" title="Link to this
heading">¶</a></h4>
+<section id="id130">
+<h4>Aliases<a class="headerlink" href="#id130" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_remove</p></li>
</ul>
@@ -5424,8 +5490,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_remove_n</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">element</span><span class="p">,</span> <span
class="nb">max</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id129">
-<h4>Arguments<a class="headerlink" href="#id129" title="Link to this
heading">¶</a></h4>
+<section id="id131">
+<h4>Arguments<a class="headerlink" href="#id131" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -5433,8 +5499,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<li><p><strong>max</strong>: Number of first occurrences to remove.</p></li>
</ul>
</section>
-<section id="id130">
-<h4>Example<a class="headerlink" href="#id130" title="Link to this
heading">¶</a></h4>
+<section id="id132">
+<h4>Example<a class="headerlink" href="#id132" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_remove_n([1, 2, 2, 3, 2, 1,
4], 2, 2);
+---------------------------------------------------------+
| array_remove_n(List([1,2,2,3,2,1,4]),Int64(2),Int64(2)) |
@@ -5444,8 +5510,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id131">
-<h4>Aliases<a class="headerlink" href="#id131" title="Link to this
heading">¶</a></h4>
+<section id="id133">
+<h4>Aliases<a class="headerlink" href="#id133" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_remove_n</p></li>
</ul>
@@ -5457,16 +5523,16 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span
class="n">array_remove_all</span><span class="p">(</span><span
class="n">array</span><span class="p">,</span> <span
class="n">element</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id132">
-<h4>Arguments<a class="headerlink" href="#id132" title="Link to this
heading">¶</a></h4>
+<section id="id134">
+<h4>Arguments<a class="headerlink" href="#id134" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
<li><p><strong>element</strong>: Element to be removed from the array.</p></li>
</ul>
</section>
-<section id="id133">
-<h4>Example<a class="headerlink" href="#id133" title="Link to this
heading">¶</a></h4>
+<section id="id135">
+<h4>Example<a class="headerlink" href="#id135" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_remove_all([1, 2, 2, 3, 2,
1, 4], 2);
+--------------------------------------------------+
| array_remove_all(List([1,2,2,3,2,1,4]),Int64(2)) |
@@ -5476,8 +5542,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id134">
-<h4>Aliases<a class="headerlink" href="#id134" title="Link to this
heading">¶</a></h4>
+<section id="id136">
+<h4>Aliases<a class="headerlink" href="#id136" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_remove_all</p></li>
</ul>
@@ -5489,8 +5555,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_replace</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">from</span><span class="p">,</span> <span class="n">to</span><span
class="p">)</span>
</pre></div>
</div>
-<section id="id135">
-<h4>Arguments<a class="headerlink" href="#id135" title="Link to this
heading">¶</a></h4>
+<section id="id137">
+<h4>Arguments<a class="headerlink" href="#id137" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -5498,8 +5564,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<li><p><strong>to</strong>: Final element.</p></li>
</ul>
</section>
-<section id="id136">
-<h4>Example<a class="headerlink" href="#id136" title="Link to this
heading">¶</a></h4>
+<section id="id138">
+<h4>Example<a class="headerlink" href="#id138" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_replace([1, 2, 2, 3, 2, 1,
4], 2, 5);
+--------------------------------------------------------+
| array_replace(List([1,2,2,3,2,1,4]),Int64(2),Int64(5)) |
@@ -5509,8 +5575,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id137">
-<h4>Aliases<a class="headerlink" href="#id137" title="Link to this
heading">¶</a></h4>
+<section id="id139">
+<h4>Aliases<a class="headerlink" href="#id139" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_replace</p></li>
</ul>
@@ -5522,8 +5588,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_replace_n</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">from</span><span class="p">,</span> <span class="n">to</span><span
class="p">,</span> <span class="nb">max</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id138">
-<h4>Arguments<a class="headerlink" href="#id138" title="Link to this
heading">¶</a></h4>
+<section id="id140">
+<h4>Arguments<a class="headerlink" href="#id140" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -5532,8 +5598,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<li><p><strong>max</strong>: Number of first occurrences to replace.</p></li>
</ul>
</section>
-<section id="id139">
-<h4>Example<a class="headerlink" href="#id139" title="Link to this
heading">¶</a></h4>
+<section id="id141">
+<h4>Example<a class="headerlink" href="#id141" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_replace_n([1, 2, 2, 3, 2, 1,
4], 2, 5, 2);
+-------------------------------------------------------------------+
| array_replace_n(List([1,2,2,3,2,1,4]),Int64(2),Int64(5),Int64(2)) |
@@ -5543,8 +5609,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id140">
-<h4>Aliases<a class="headerlink" href="#id140" title="Link to this
heading">¶</a></h4>
+<section id="id142">
+<h4>Aliases<a class="headerlink" href="#id142" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_replace_n</p></li>
</ul>
@@ -5556,8 +5622,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span
class="n">array_replace_all</span><span class="p">(</span><span
class="n">array</span><span class="p">,</span> <span class="n">from</span><span
class="p">,</span> <span class="n">to</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id141">
-<h4>Arguments<a class="headerlink" href="#id141" title="Link to this
heading">¶</a></h4>
+<section id="id143">
+<h4>Arguments<a class="headerlink" href="#id143" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -5565,8 +5631,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<li><p><strong>to</strong>: Final element.</p></li>
</ul>
</section>
-<section id="id142">
-<h4>Example<a class="headerlink" href="#id142" title="Link to this
heading">¶</a></h4>
+<section id="id144">
+<h4>Example<a class="headerlink" href="#id144" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_replace_all([1, 2, 2, 3, 2,
1, 4], 2, 5);
+------------------------------------------------------------+
| array_replace_all(List([1,2,2,3,2,1,4]),Int64(2),Int64(5)) |
@@ -5576,8 +5642,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id143">
-<h4>Aliases<a class="headerlink" href="#id143" title="Link to this
heading">¶</a></h4>
+<section id="id145">
+<h4>Aliases<a class="headerlink" href="#id145" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_replace_all</p></li>
</ul>
@@ -5589,8 +5655,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_slice</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">begin</span><span class="p">,</span> <span class="n">end</span><span
class="p">)</span>
</pre></div>
</div>
-<section id="id144">
-<h4>Example<a class="headerlink" href="#id144" title="Link to this
heading">¶</a></h4>
+<section id="id146">
+<h4>Example<a class="headerlink" href="#id146" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_slice([1, 2, 3, 4, 5, 6, 7,
8], 3, 6);
+--------------------------------------------------------+
| array_slice(List([1,2,3,4,5,6,7,8]),Int64(3),Int64(6)) |
@@ -5600,8 +5666,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id145">
-<h4>Aliases<a class="headerlink" href="#id145" title="Link to this
heading">¶</a></h4>
+<section id="id147">
+<h4>Aliases<a class="headerlink" href="#id147" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_slice</p></li>
</ul>
@@ -5613,16 +5679,16 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_to_string</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">delimiter</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id146">
-<h4>Arguments<a class="headerlink" href="#id146" title="Link to this
heading">¶</a></h4>
+<section id="id148">
+<h4>Arguments<a class="headerlink" href="#id148" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
<li><p><strong>delimiter</strong>: Array element separator.</p></li>
</ul>
</section>
-<section id="id147">
-<h4>Example<a class="headerlink" href="#id147" title="Link to this
heading">¶</a></h4>
+<section id="id149">
+<h4>Example<a class="headerlink" href="#id149" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_to_string([[1, 2, 3, 4], [5,
6, 7, 8]], ',');
+----------------------------------------------------+
| array_to_string(List([1,2,3,4,5,6,7,8]),Utf8(",")) |
@@ -5632,8 +5698,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id148">
-<h4>Aliases<a class="headerlink" href="#id148" title="Link to this
heading">¶</a></h4>
+<section id="id150">
+<h4>Aliases<a class="headerlink" href="#id150" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>array_join</p></li>
<li><p>list_join</p></li>
@@ -5647,8 +5713,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_union</span><span
class="p">(</span><span class="n">array1</span><span class="p">,</span> <span
class="n">array2</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id149">
-<h4>Arguments<a class="headerlink" href="#id149" title="Link to this
heading">¶</a></h4>
+<section id="id151">
+<h4>Arguments<a class="headerlink" href="#id151" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array1</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -5656,8 +5722,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
Can be a constant, column, or function, and any combination of array
operators.</p></li>
</ul>
</section>
-<section id="id150">
-<h4>Example<a class="headerlink" href="#id150" title="Link to this
heading">¶</a></h4>
+<section id="id152">
+<h4>Example<a class="headerlink" href="#id152" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_union([1, 2, 3, 4], [5, 6,
3, 4]);
+----------------------------------------------------+
| array_union([1, 2, 3, 4], [5, 6, 3, 4]); |
@@ -5674,8 +5740,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</div>
</section>
<hr class="docutils" />
-<section id="id151">
-<h4>Aliases<a class="headerlink" href="#id151" title="Link to this
heading">¶</a></h4>
+<section id="id153">
+<h4>Aliases<a class="headerlink" href="#id153" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_union</p></li>
</ul>
@@ -5687,8 +5753,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_except</span><span
class="p">(</span><span class="n">array1</span><span class="p">,</span> <span
class="n">array2</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id152">
-<h4>Arguments<a class="headerlink" href="#id152" title="Link to this
heading">¶</a></h4>
+<section id="id154">
+<h4>Arguments<a class="headerlink" href="#id154" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array1</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -5696,8 +5762,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
Can be a constant, column, or function, and any combination of array
operators.</p></li>
</ul>
</section>
-<section id="id153">
-<h4>Example<a class="headerlink" href="#id153" title="Link to this
heading">¶</a></h4>
+<section id="id155">
+<h4>Example<a class="headerlink" href="#id155" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_except([1, 2, 3, 4], [5, 6,
3, 4]);
+----------------------------------------------------+
| array_except([1, 2, 3, 4], [5, 6, 3, 4]); |
@@ -5714,8 +5780,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</div>
</section>
<hr class="docutils" />
-<section id="id154">
-<h4>Aliases<a class="headerlink" href="#id154" title="Link to this
heading">¶</a></h4>
+<section id="id156">
+<h4>Aliases<a class="headerlink" href="#id156" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_except</p></li>
</ul>
@@ -5727,15 +5793,15 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">cardinality</span><span
class="p">(</span><span class="n">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id155">
-<h4>Arguments<a class="headerlink" href="#id155" title="Link to this
heading">¶</a></h4>
+<section id="id157">
+<h4>Arguments<a class="headerlink" href="#id157" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
</ul>
</section>
-<section id="id156">
-<h4>Example<a class="headerlink" href="#id156" title="Link to this
heading">¶</a></h4>
+<section id="id158">
+<h4>Example<a class="headerlink" href="#id158" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select cardinality([[1, 2, 3, 4], [5, 6,
7, 8]]);
+--------------------------------------+
| cardinality(List([1,2,3,4,5,6,7,8])) |
@@ -5752,15 +5818,15 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">empty</span><span
class="p">(</span><span class="n">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id157">
-<h4>Arguments<a class="headerlink" href="#id157" title="Link to this
heading">¶</a></h4>
+<section id="id159">
+<h4>Arguments<a class="headerlink" href="#id159" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
</ul>
</section>
-<section id="id158">
-<h4>Example<a class="headerlink" href="#id158" title="Link to this
heading">¶</a></h4>
+<section id="id160">
+<h4>Example<a class="headerlink" href="#id160" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select empty([1]);
+------------------+
| empty(List([1])) |
@@ -5877,16 +5943,16 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">make_array</span><span
class="p">(</span><span class="n">expression1</span><span class="p">[,</span>
<span class="o">...</span><span class="p">,</span> <span
class="n">expression_n</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id159">
-<h4>Arguments<a class="headerlink" href="#id159" title="Link to this
heading">¶</a></h4>
+<section id="id161">
+<h4>Arguments<a class="headerlink" href="#id161" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression_n</strong>: Expression to include in the output
array.
Can be a constant, column, or function, and any combination of arithmetic or
string operators.</p></li>
</ul>
</section>
-<section id="id160">
-<h4>Example<a class="headerlink" href="#id160" title="Link to this
heading">¶</a></h4>
+<section id="id162">
+<h4>Example<a class="headerlink" href="#id162" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select make_array(1, 2, 3, 4, 5);
+----------------------------------------------------------+
| make_array(Int64(1),Int64(2),Int64(3),Int64(4),Int64(5)) |
@@ -5896,8 +5962,8 @@ string operators.</p></li>
</pre></div>
</div>
</section>
-<section id="id161">
-<h4>Aliases<a class="headerlink" href="#id161" title="Link to this
heading">¶</a></h4>
+<section id="id163">
+<h4>Aliases<a class="headerlink" href="#id163" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>make_list</p></li>
</ul>
@@ -5913,16 +5979,16 @@ string operators.</p></li>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">starts_with</span><span
class="p">(</span><span class="nb">str</span><span class="p">,</span> <span
class="n">delimiter</span><span class="p">[,</span> <span
class="n">null_str</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id162">
-<h4>Arguments<a class="headerlink" href="#id162" title="Link to this
heading">¶</a></h4>
+<section id="id164">
+<h4>Arguments<a class="headerlink" href="#id164" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to split.</p></li>
<li><p><strong>delimiter</strong>: Delimiter string to split on.</p></li>
<li><p><strong>null_str</strong>: Substring values to be replaced with <code
class="docutils literal notranslate"><span
class="pre">NULL</span></code></p></li>
</ul>
</section>
-<section id="id163">
-<h4>Aliases<a class="headerlink" href="#id163" title="Link to this
heading">¶</a></h4>
+<section id="id165">
+<h4>Aliases<a class="headerlink" href="#id165" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>string_to_list</p></li>
</ul>
@@ -5939,8 +6005,8 @@ string operators.</p></li>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">trim_array</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">n</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id164">
-<h4>Arguments<a class="headerlink" href="#id164" title="Link to this
heading">¶</a></h4>
+<section id="id166">
+<h4>Arguments<a class="headerlink" href="#id166" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -5953,8 +6019,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<p>Returns an Arrow array between start and stop with step. <code
class="docutils literal notranslate"><span class="pre">SELECT</span> <span
class="pre">range(2,</span> <span class="pre">10,</span> <span
class="pre">3)</span> <span class="pre">-></span> <span
class="pre">[2,</span> <span class="pre">5,</span> <span
class="pre">8]</span></code></p>
<p>The range start..end contains all values with start <= x < end. It is
empty if start >= end.</p>
<p>Step can not be 0 (then the range will be nonsense.).</p>
-<section id="id165">
-<h4>Arguments<a class="headerlink" href="#id165" title="Link to this
heading">¶</a></h4>
+<section id="id167">
+<h4>Arguments<a class="headerlink" href="#id167" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>start</strong>: start of the range</p></li>
<li><p><strong>end</strong>: end of the range (not included)</p></li>
@@ -5995,8 +6061,8 @@ a struct type of fields <code class="docutils literal
notranslate"><span class="
<span class="o">+</span><span class="c1">-----------------+</span>
</pre></div>
</div>
-<section id="id166">
-<h4>Arguments<a class="headerlink" href="#id166" title="Link to this
heading">¶</a></h4>
+<section id="id168">
+<h4>Arguments<a class="headerlink" href="#id168" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression_n</strong>: Expression to include in the output
struct.
Can be a constant, column, or function, and any combination of arithmetic or
@@ -6021,8 +6087,8 @@ string operators.</p></li>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">digest</span><span
class="p">(</span><span class="n">expression</span><span class="p">,</span>
<span class="n">algorithm</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id167">
-<h4>Arguments<a class="headerlink" href="#id167" title="Link to this
heading">¶</a></h4>
+<section id="id169">
+<h4>Arguments<a class="headerlink" href="#id169" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -6048,8 +6114,8 @@ Must be one of:</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">md5</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id168">
-<h4>Arguments<a class="headerlink" href="#id168" title="Link to this
heading">¶</a></h4>
+<section id="id170">
+<h4>Arguments<a class="headerlink" href="#id170" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -6062,8 +6128,8 @@ Can be a constant, column, or function, and any
combination of string operators.
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">sha224</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id169">
-<h4>Arguments<a class="headerlink" href="#id169" title="Link to this
heading">¶</a></h4>
+<section id="id171">
+<h4>Arguments<a class="headerlink" href="#id171" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -6076,8 +6142,8 @@ Can be a constant, column, or function, and any
combination of string operators.
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">sha256</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id170">
-<h4>Arguments<a class="headerlink" href="#id170" title="Link to this
heading">¶</a></h4>
+<section id="id172">
+<h4>Arguments<a class="headerlink" href="#id172" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -6090,8 +6156,8 @@ Can be a constant, column, or function, and any
combination of string operators.
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">sha384</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id171">
-<h4>Arguments<a class="headerlink" href="#id171" title="Link to this
heading">¶</a></h4>
+<section id="id173">
+<h4>Arguments<a class="headerlink" href="#id173" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -6104,8 +6170,8 @@ Can be a constant, column, or function, and any
combination of string operators.
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">sha512</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id172">
-<h4>Arguments<a class="headerlink" href="#id172" title="Link to this
heading">¶</a></h4>
+<section id="id174">
+<h4>Arguments<a class="headerlink" href="#id174" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -6125,8 +6191,8 @@ Can be a constant, column, or function, and any
combination of string operators.
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">arrow_cast</span><span
class="p">(</span><span class="n">expression</span><span class="p">,</span>
<span class="n">datatype</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id173">
-<h4>Arguments<a class="headerlink" href="#id173" title="Link to this
heading">¶</a></h4>
+<section id="id175">
+<h4>Arguments<a class="headerlink" href="#id175" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to cast.
Can be a constant, column, or function, and any combination of arithmetic or
@@ -6135,8 +6201,8 @@ string operators.</p></li>
to cast to, as a string. The format is the same as that returned by [<code
class="docutils literal notranslate"><span
class="pre">arrow_typeof</span></code>]</p></li>
</ul>
</section>
-<section id="id174">
-<h4>Example<a class="headerlink" href="#id174" title="Link to this
heading">¶</a></h4>
+<section id="id176">
+<h4>Example<a class="headerlink" href="#id176" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select arrow_cast(-5, 'Int8') as
a,
arrow_cast('foo', 'Dictionary(Int32, Utf8)') as b,
arrow_cast('bar', 'LargeUtf8') as c,
@@ -6158,16 +6224,16 @@ to cast to, as a string. The format is the same as that
returned by [<code class
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">arrow_typeof</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id175">
-<h4>Arguments<a class="headerlink" href="#id175" title="Link to this
heading">¶</a></h4>
+<section id="id177">
+<h4>Arguments<a class="headerlink" href="#id177" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to evaluate.
Can be a constant, column, or function, and any combination of arithmetic or
string operators.</p></li>
</ul>
</section>
-<section id="id176">
-<h4>Example<a class="headerlink" href="#id176" title="Link to this
heading">¶</a></h4>
+<section id="id178">
+<h4>Example<a class="headerlink" href="#id178" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select arrow_typeof('foo'),
arrow_typeof(1);
+---------------------------+------------------------+
| arrow_typeof(Utf8("foo")) | arrow_typeof(Int64(1)) |
