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 4551417ec6 Publish built docs triggered by
cf152af6515f0808d840e1fe9c63b02802595826
4551417ec6 is described below
commit 4551417ec6f945150ef60d1120fb031cd529c6f5
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Wed Aug 16 08:29:20 2023 +0000
Publish built docs triggered by cf152af6515f0808d840e1fe9c63b02802595826
---
_sources/user-guide/expressions.md.txt | 2 +
_sources/user-guide/sql/scalar_functions.md.txt | 28 +
searchindex.js | 2 +-
user-guide/expressions.html | 6 +
user-guide/sql/scalar_functions.html | 854 +++++++++++++-----------
5 files changed, 495 insertions(+), 397 deletions(-)
diff --git a/_sources/user-guide/expressions.md.txt
b/_sources/user-guide/expressions.md.txt
index 88a5a73a6d..630b158092 100644
--- a/_sources/user-guide/expressions.md.txt
+++ b/_sources/user-guide/expressions.md.txt
@@ -94,6 +94,8 @@ expressions such as `col("a") + col("b")` to be used.
| factorial(x) | factorial |
| floor(x) | nearest integer less than or equal to argument |
| gcd(x, y) | greatest common divisor |
+| isnan(x) | predicate determining whether NaN/-NaN or not |
+| iszero(x) | predicate determining whether 0.0/-0.0 or not |
| lcm(x, y) | least common multiple |
| ln(x) | natural logarithm |
| log(base, x) | logarithm of x for a particular base |
diff --git a/_sources/user-guide/sql/scalar_functions.md.txt
b/_sources/user-guide/sql/scalar_functions.md.txt
index 9bcf2ae0b0..6dbe5c05f6 100644
--- a/_sources/user-guide/sql/scalar_functions.md.txt
+++ b/_sources/user-guide/sql/scalar_functions.md.txt
@@ -38,6 +38,8 @@
- [factorial](#factorial)
- [floor](#floor)
- [gcd](#gcd)
+- [isnan](#isnan)
+- [iszero](#iszero)
- [lcm](#lcm)
- [ln](#ln)
- [log](#log)
@@ -283,6 +285,32 @@ gcd(expression_x, expression_y)
- **expression_y**: Second numeric expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.
+### `isnan`
+
+Returns true if a given number is +NaN or -NaN otherwise returns false.
+
+```
+isnan(numeric_expression)
+```
+
+#### Arguments
+
+- **numeric_expression**: Numeric expression to operate on.
+ Can be a constant, column, or function, and any combination of arithmetic
operators.
+
+### `iszero`
+
+Returns true if a given number is +0.0 or -0.0 otherwise returns false.
+
+```
+iszero(numeric_expression)
+```
+
+#### Arguments
+
+- **numeric_expression**: Numeric expression to operate on.
+ Can be a constant, column, or function, and any combination of arithmetic
operators.
+
### `lcm`
Returns the least common multiple of `expression_x` and `expression_y`.
Returns 0 if either input is zero.
diff --git a/searchindex.js b/searchindex.js
index f5d22c4b49..0c18e87517 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",
"user-guide/cli", "user-guide/configs", "user-guide/dataframe",
"user-guide/example-usage", "user-guide/expressions", "user-guide/faq", "use
[...]
\ 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",
"user-guide/cli", "user-guide/configs", "user-guide/dataframe",
"user-guide/example-usage", "user-guide/expressions", "user-guide/faq", "use
[...]
\ No newline at end of file
diff --git a/user-guide/expressions.html b/user-guide/expressions.html
index e397f1f21d..046e4987e6 100644
--- a/user-guide/expressions.html
+++ b/user-guide/expressions.html
@@ -595,6 +595,12 @@ expressions such as <code class="docutils literal
notranslate"><span class="pre"
<tr class="row-even"><td><p>gcd(x, y)</p></td>
<td><p>greatest common divisor</p></td>
</tr>
+<tr class="row-odd"><td><p>isnan(x)</p></td>
+<td><p>predicate determining whether NaN/-NaN or not</p></td>
+</tr>
+<tr class="row-even"><td><p>iszero(x)</p></td>
+<td><p>predicate determining whether 0.0/-0.0 or not</p></td>
+</tr>
<tr class="row-odd"><td><p>lcm(x, y)</p></td>
<td><p>least common multiple</p></td>
</tr>
diff --git a/user-guide/sql/scalar_functions.html
b/user-guide/sql/scalar_functions.html
index d657c86539..cc4b49238c 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -558,6 +558,38 @@
</li>
</ul>
</li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#isnan">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ isnan
+ </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="#id17">
+ Arguments
+ </a>
+ </li>
+ </ul>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#iszero">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ iszero
+ </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="#id18">
+ Arguments
+ </a>
+ </li>
+ </ul>
+ </li>
<li class="toc-h3 nav-item toc-entry">
<a class="reference internal nav-link" href="#lcm">
<code class="docutils literal notranslate">
@@ -568,7 +600,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id17">
+ <a class="reference internal nav-link" href="#id19">
Arguments
</a>
</li>
@@ -584,7 +616,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id18">
+ <a class="reference internal nav-link" href="#id20">
Arguments
</a>
</li>
@@ -600,7 +632,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id19">
+ <a class="reference internal nav-link" href="#id21">
Arguments
</a>
</li>
@@ -616,7 +648,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id20">
+ <a class="reference internal nav-link" href="#id22">
Arguments
</a>
</li>
@@ -632,7 +664,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id21">
+ <a class="reference internal nav-link" href="#id23">
Arguments
</a>
</li>
@@ -648,7 +680,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id22">
+ <a class="reference internal nav-link" href="#id24">
Arguments
</a>
</li>
@@ -673,7 +705,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id23">
+ <a class="reference internal nav-link" href="#id25">
Arguments
</a>
</li>
@@ -703,7 +735,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id24">
+ <a class="reference internal nav-link" href="#id26">
Arguments
</a>
</li>
@@ -728,7 +760,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id25">
+ <a class="reference internal nav-link" href="#id27">
Arguments
</a>
</li>
@@ -744,7 +776,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id26">
+ <a class="reference internal nav-link" href="#id28">
Arguments
</a>
</li>
@@ -760,7 +792,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id27">
+ <a class="reference internal nav-link" href="#id29">
Arguments
</a>
</li>
@@ -776,7 +808,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id28">
+ <a class="reference internal nav-link" href="#id30">
Arguments
</a>
</li>
@@ -792,7 +824,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id29">
+ <a class="reference internal nav-link" href="#id31">
Arguments
</a>
</li>
@@ -808,7 +840,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id30">
+ <a class="reference internal nav-link" href="#id32">
Arguments
</a>
</li>
@@ -824,7 +856,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id31">
+ <a class="reference internal nav-link" href="#id33">
Arguments
</a>
</li>
@@ -840,7 +872,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id32">
+ <a class="reference internal nav-link" href="#id34">
Arguments
</a>
</li>
@@ -863,7 +895,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id33">
+ <a class="reference internal nav-link" href="#id35">
Arguments
</a>
</li>
@@ -879,7 +911,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id34">
+ <a class="reference internal nav-link" href="#id36">
Arguments
</a>
</li>
@@ -902,7 +934,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id35">
+ <a class="reference internal nav-link" href="#id37">
Arguments
</a>
</li>
@@ -918,7 +950,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id36">
+ <a class="reference internal nav-link" href="#id38">
Arguments
</a>
</li>
@@ -934,7 +966,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id37">
+ <a class="reference internal nav-link" href="#id39">
Arguments
</a>
</li>
@@ -968,7 +1000,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id38">
+ <a class="reference internal nav-link" href="#id40">
Arguments
</a>
</li>
@@ -984,7 +1016,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id39">
+ <a class="reference internal nav-link" href="#id41">
Arguments
</a>
</li>
@@ -1000,7 +1032,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id40">
+ <a class="reference internal nav-link" href="#id42">
Arguments
</a>
</li>
@@ -1016,7 +1048,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id41">
+ <a class="reference internal nav-link" href="#id43">
Arguments
</a>
</li>
@@ -1032,7 +1064,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id42">
+ <a class="reference internal nav-link" href="#id44">
Arguments
</a>
</li>
@@ -1048,12 +1080,12 @@
</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="#id45">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id44">
+ <a class="reference internal nav-link" href="#id46">
Aliases
</a>
</li>
@@ -1069,7 +1101,7 @@
</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>
@@ -1085,7 +1117,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id46">
+ <a class="reference internal nav-link" href="#id48">
Arguments
</a>
</li>
@@ -1101,12 +1133,12 @@
</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>
<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>
@@ -1122,7 +1154,7 @@
</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>
@@ -1138,7 +1170,7 @@
</a>
<ul class="nav section-nav flex-column">
<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>
@@ -1154,7 +1186,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>
@@ -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="#id52">
+ <a class="reference internal nav-link" href="#id54">
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="#id53">
+ <a class="reference internal nav-link" href="#id55">
Arguments
</a>
</li>
@@ -1202,7 +1234,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>
@@ -1218,7 +1250,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>
@@ -1234,7 +1266,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>
@@ -1250,7 +1282,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>
@@ -1266,7 +1298,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>
@@ -1282,7 +1314,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>
@@ -1307,7 +1339,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>
@@ -1323,7 +1355,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>
@@ -1339,7 +1371,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>
@@ -1371,7 +1403,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>
@@ -1387,7 +1419,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>
@@ -1410,7 +1442,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>
@@ -1426,7 +1458,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>
@@ -1476,7 +1508,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>
@@ -1492,12 +1524,12 @@
</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>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id69">
+ <a class="reference internal nav-link" href="#id71">
Aliases
</a>
</li>
@@ -1522,12 +1554,12 @@
</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>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id71">
+ <a class="reference internal nav-link" href="#id73">
Aliases
</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="#id72">
+ <a class="reference internal nav-link" href="#id74">
Arguments
</a>
</li>
@@ -1568,7 +1600,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">
Arguments
</a>
</li>
@@ -1584,7 +1616,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>
@@ -1600,7 +1632,7 @@
</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>
@@ -1616,7 +1648,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id76">
+ <a class="reference internal nav-link" href="#id78">
Arguments
</a>
</li>
@@ -1632,7 +1664,7 @@
</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>
@@ -1655,7 +1687,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id78">
+ <a class="reference internal nav-link" href="#id80">
Arguments
</a>
</li>
@@ -1665,7 +1697,7 @@
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id79">
+ <a class="reference internal nav-link" href="#id81">
Aliases
</a>
</li>
@@ -1690,17 +1722,17 @@
</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>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id81">
+ <a class="reference internal nav-link" href="#id83">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id82">
+ <a class="reference internal nav-link" href="#id84">
Aliases
</a>
</li>
@@ -1716,7 +1748,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>
@@ -1732,7 +1764,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>
@@ -1748,7 +1780,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>
@@ -1764,17 +1796,17 @@
</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>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id87">
+ <a class="reference internal nav-link" href="#id89">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id88">
+ <a class="reference internal nav-link" href="#id90">
Aliases
</a>
</li>
@@ -1790,17 +1822,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id89">
+ <a class="reference internal nav-link" href="#id91">
Arguments
</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">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id91">
+ <a class="reference internal nav-link" href="#id93">
Aliases
</a>
</li>
@@ -1825,7 +1857,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id92">
+ <a class="reference internal nav-link" href="#id94">
Arguments
</a>
</li>
@@ -1841,7 +1873,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id93">
+ <a class="reference internal nav-link" href="#id95">
Arguments
</a>
</li>
@@ -1875,17 +1907,17 @@
</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>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id95">
+ <a class="reference internal nav-link" href="#id97">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id96">
+ <a class="reference internal nav-link" href="#id98">
Aliases
</a>
</li>
@@ -1901,17 +1933,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>
@@ -1927,17 +1959,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>
@@ -1953,17 +1985,17 @@
</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>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id104">
+ <a class="reference internal nav-link" href="#id106">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id105">
+ <a class="reference internal nav-link" href="#id107">
Aliases
</a>
</li>
@@ -1979,17 +2011,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id106">
+ <a class="reference internal nav-link" href="#id108">
Arguments
</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">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id108">
+ <a class="reference internal nav-link" href="#id110">
Aliases
</a>
</li>
@@ -2023,12 +2055,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id109">
+ <a class="reference internal nav-link" href="#id111">
Arguments
</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">
Example
</a>
</li>
@@ -2044,17 +2076,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>
@@ -2070,17 +2102,17 @@
</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>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id116">
+ <a class="reference internal nav-link" href="#id118">
Aliases
</a>
</li>
@@ -2096,17 +2128,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id117">
+ <a class="reference internal nav-link" href="#id119">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id118">
+ <a class="reference internal nav-link" href="#id120">
Example
</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">
Aliases
</a>
</li>
@@ -2122,17 +2154,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id120">
+ <a class="reference internal nav-link" href="#id122">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id121">
+ <a class="reference internal nav-link" href="#id123">
Example
</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">
Aliases
</a>
</li>
@@ -2148,17 +2180,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id123">
+ <a class="reference internal nav-link" href="#id125">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id124">
+ <a class="reference internal nav-link" href="#id126">
Example
</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">
Aliases
</a>
</li>
@@ -2174,17 +2206,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>
@@ -2200,12 +2232,12 @@
</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">
Example
</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">
Aliases
</a>
</li>
@@ -2221,17 +2253,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id131">
+ <a class="reference internal nav-link" href="#id133">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id132">
+ <a class="reference internal nav-link" href="#id134">
Example
</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">
Aliases
</a>
</li>
@@ -2247,12 +2279,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id134">
+ <a class="reference internal nav-link" href="#id136">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id135">
+ <a class="reference internal nav-link" href="#id137">
Example
</a>
</li>
@@ -2484,17 +2516,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id136">
+ <a class="reference internal nav-link" href="#id138">
Arguments
</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">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id138">
+ <a class="reference internal nav-link" href="#id140">
Aliases
</a>
</li>
@@ -2519,7 +2551,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id139">
+ <a class="reference internal nav-link" href="#id141">
Arguments
</a>
</li>
@@ -2542,7 +2574,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id140">
+ <a class="reference internal nav-link" href="#id142">
Arguments
</a>
</li>
@@ -2565,7 +2597,7 @@
</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>
@@ -2581,7 +2613,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id142">
+ <a class="reference internal nav-link" href="#id144">
Arguments
</a>
</li>
@@ -2597,7 +2629,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id143">
+ <a class="reference internal nav-link" href="#id145">
Arguments
</a>
</li>
@@ -2613,7 +2645,7 @@
</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">
Arguments
</a>
</li>
@@ -2629,7 +2661,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id145">
+ <a class="reference internal nav-link" href="#id147">
Arguments
</a>
</li>
@@ -2645,7 +2677,7 @@
</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>
@@ -2668,7 +2700,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id147">
+ <a class="reference internal nav-link" href="#id149">
Arguments
</a>
</li>
@@ -2684,7 +2716,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id148">
+ <a class="reference internal nav-link" href="#id150">
Arguments
</a>
</li>
@@ -2760,6 +2792,8 @@
<li><p><a class="reference internal" href="#factorial">factorial</a></p></li>
<li><p><a class="reference internal" href="#floor">floor</a></p></li>
<li><p><a class="reference internal" href="#gcd">gcd</a></p></li>
+<li><p><a class="reference internal" href="#isnan">isnan</a></p></li>
+<li><p><a class="reference internal" href="#iszero">iszero</a></p></li>
<li><p><a class="reference internal" href="#lcm">lcm</a></p></li>
<li><p><a class="reference internal" href="#ln">ln</a></p></li>
<li><p><a class="reference internal" href="#log">log</a></p></li>
@@ -3022,14 +3056,42 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
</ul>
</section>
</section>
+<section id="isnan">
+<h3><code class="docutils literal notranslate"><span
class="pre">isnan</span></code><a class="headerlink" href="#isnan"
title="Permalink to this heading">¶</a></h3>
+<p>Returns true if a given number is +NaN or -NaN otherwise returns false.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">isnan</span><span
class="p">(</span><span class="n">numeric_expression</span><span
class="p">)</span>
+</pre></div>
+</div>
+<section id="id17">
+<h4>Arguments<a class="headerlink" href="#id17" title="Permalink to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p><strong>numeric_expression</strong>: Numeric expression to operate on.
+Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
+</ul>
+</section>
+</section>
+<section id="iszero">
+<h3><code class="docutils literal notranslate"><span
class="pre">iszero</span></code><a class="headerlink" href="#iszero"
title="Permalink to this heading">¶</a></h3>
+<p>Returns true if a given number is +0.0 or -0.0 otherwise returns false.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">iszero</span><span
class="p">(</span><span class="n">numeric_expression</span><span
class="p">)</span>
+</pre></div>
+</div>
+<section id="id18">
+<h4>Arguments<a class="headerlink" href="#id18" title="Permalink to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p><strong>numeric_expression</strong>: Numeric expression to operate on.
+Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
+</ul>
+</section>
+</section>
<section id="lcm">
<h3><code class="docutils literal notranslate"><span
class="pre">lcm</span></code><a class="headerlink" href="#lcm" title="Permalink
to this heading">¶</a></h3>
<p>Returns the least common multiple of <code class="docutils literal
notranslate"><span class="pre">expression_x</span></code> and <code
class="docutils literal notranslate"><span
class="pre">expression_y</span></code>. Returns 0 if either input is zero.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">lcm</span><span
class="p">(</span><span class="n">expression_x</span><span class="p">,</span>
<span class="n">expression_y</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id17">
-<h4>Arguments<a class="headerlink" href="#id17" title="Permalink to this
heading">¶</a></h4>
+<section id="id19">
+<h4>Arguments<a class="headerlink" href="#id19" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression_x</strong>: First numeric expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -3044,8 +3106,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">ln</span><span
class="p">(</span><span class="n">numeric_expression</span><span
class="p">)</span>
</pre></div>
</div>
-<section id="id18">
-<h4>Arguments<a class="headerlink" href="#id18" title="Permalink to this
heading">¶</a></h4>
+<section id="id20">
+<h4>Arguments<a class="headerlink" href="#id20" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>numeric_expression</strong>: Numeric expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -3060,8 +3122,8 @@ Can either provide a specified base, or if omitted then
takes the base-10 of a n
<span class="n">log</span><span class="p">(</span><span
class="n">numeric_expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id19">
-<h4>Arguments<a class="headerlink" href="#id19" title="Permalink to this
heading">¶</a></h4>
+<section id="id21">
+<h4>Arguments<a class="headerlink" href="#id21" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>base</strong>: Base numeric expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -3076,8 +3138,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">log10</span><span
class="p">(</span><span class="n">numeric_expression</span><span
class="p">)</span>
</pre></div>
</div>
-<section id="id20">
-<h4>Arguments<a class="headerlink" href="#id20" title="Permalink to this
heading">¶</a></h4>
+<section id="id22">
+<h4>Arguments<a class="headerlink" href="#id22" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>numeric_expression</strong>: Numeric expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -3090,8 +3152,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">log2</span><span
class="p">(</span><span class="n">numeric_expression</span><span
class="p">)</span>
</pre></div>
</div>
-<section id="id21">
-<h4>Arguments<a class="headerlink" href="#id21" title="Permalink to this
heading">¶</a></h4>
+<section id="id23">
+<h4>Arguments<a class="headerlink" href="#id23" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>numeric_expression</strong>: Numeric expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -3105,8 +3167,8 @@ Returns the second argument otherwise.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">nanvl</span><span
class="p">(</span><span class="n">expression_x</span><span class="p">,</span>
<span class="n">expression_y</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id22">
-<h4>Arguments<a class="headerlink" href="#id22" title="Permalink to this
heading">¶</a></h4>
+<section id="id24">
+<h4>Arguments<a class="headerlink" href="#id24" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression_x</strong>: Numeric expression to return if it’s not
<em>NaN</em>.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -3128,8 +3190,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">power</span><span
class="p">(</span><span class="n">base</span><span class="p">,</span> <span
class="n">exponent</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id23">
-<h4>Arguments<a class="headerlink" href="#id23" title="Permalink to this
heading">¶</a></h4>
+<section id="id25">
+<h4>Arguments<a class="headerlink" href="#id25" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>base</strong>: Numeric expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -3154,8 +3216,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">radians</span><span
class="p">(</span><span class="n">numeric_expression</span><span
class="p">)</span>
</pre></div>
</div>
-<section id="id24">
-<h4>Arguments<a class="headerlink" href="#id24" title="Permalink to this
heading">¶</a></h4>
+<section id="id26">
+<h4>Arguments<a class="headerlink" href="#id26" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>numeric_expression</strong>: Numeric expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -3176,8 +3238,8 @@ The random seed is unique to each row.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="nb">round</span><span
class="p">(</span><span class="n">numeric_expression</span><span
class="p">[,</span> <span class="n">decimal_places</span><span
class="p">])</span>
</pre></div>
</div>
-<section id="id25">
-<h4>Arguments<a class="headerlink" href="#id25" title="Permalink to this
heading">¶</a></h4>
+<section id="id27">
+<h4>Arguments<a class="headerlink" href="#id27" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>numeric_expression</strong>: Numeric expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -3194,8 +3256,8 @@ Zero and positive numbers return <code class="docutils
literal notranslate"><spa
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">signum</span><span
class="p">(</span><span class="n">numeric_expression</span><span
class="p">)</span>
</pre></div>
</div>
-<section id="id26">
-<h4>Arguments<a class="headerlink" href="#id26" title="Permalink to this
heading">¶</a></h4>
+<section id="id28">
+<h4>Arguments<a class="headerlink" href="#id28" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>numeric_expression</strong>: Numeric expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -3208,8 +3270,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">sin</span><span
class="p">(</span><span class="n">numeric_expression</span><span
class="p">)</span>
</pre></div>
</div>
-<section id="id27">
-<h4>Arguments<a class="headerlink" href="#id27" title="Permalink to this
heading">¶</a></h4>
+<section id="id29">
+<h4>Arguments<a class="headerlink" href="#id29" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>numeric_expression</strong>: Numeric expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -3222,8 +3284,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">sinh</span><span
class="p">(</span><span class="n">numeric_expression</span><span
class="p">)</span>
</pre></div>
</div>
-<section id="id28">
-<h4>Arguments<a class="headerlink" href="#id28" title="Permalink to this
heading">¶</a></h4>
+<section id="id30">
+<h4>Arguments<a class="headerlink" href="#id30" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>numeric_expression</strong>: Numeric expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -3236,8 +3298,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">sqrt</span><span
class="p">(</span><span class="n">numeric_expression</span><span
class="p">)</span>
</pre></div>
</div>
-<section id="id29">
-<h4>Arguments<a class="headerlink" href="#id29" title="Permalink to this
heading">¶</a></h4>
+<section id="id31">
+<h4>Arguments<a class="headerlink" href="#id31" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>numeric_expression</strong>: Numeric expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -3250,8 +3312,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">tan</span><span
class="p">(</span><span class="n">numeric_expression</span><span
class="p">)</span>
</pre></div>
</div>
-<section id="id30">
-<h4>Arguments<a class="headerlink" href="#id30" title="Permalink to this
heading">¶</a></h4>
+<section id="id32">
+<h4>Arguments<a class="headerlink" href="#id32" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>numeric_expression</strong>: Numeric expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -3264,8 +3326,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">tanh</span><span
class="p">(</span><span class="n">numeric_expression</span><span
class="p">)</span>
</pre></div>
</div>
-<section id="id31">
-<h4>Arguments<a class="headerlink" href="#id31" title="Permalink to this
heading">¶</a></h4>
+<section id="id33">
+<h4>Arguments<a class="headerlink" href="#id33" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>numeric_expression</strong>: Numeric expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -3278,8 +3340,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">trunc</span><span
class="p">(</span><span class="n">numeric_expression</span><span
class="p">[,</span> <span class="n">decimal_places</span><span
class="p">])</span>
</pre></div>
</div>
-<section id="id32">
-<h4>Arguments<a class="headerlink" href="#id32" title="Permalink to this
heading">¶</a></h4>
+<section id="id34">
+<h4>Arguments<a class="headerlink" href="#id34" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>numeric_expression</strong>: Numeric expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -3306,8 +3368,8 @@ This function is often used to substitute a default value
for <em>null</em> valu
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">coalesce</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="id33">
-<h4>Arguments<a class="headerlink" href="#id33" title="Permalink to this
heading">¶</a></h4>
+<section id="id35">
+<h4>Arguments<a class="headerlink" href="#id35" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression1, expression_n</strong>:
Expression to use if previous expressions are <em>null</em>.
@@ -3323,8 +3385,8 @@ This can be used to perform the inverse operation of <a
class="reference interna
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">nullif</span><span
class="p">(</span><span class="n">expression1</span><span class="p">,</span>
<span class="n">expression2</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id34">
-<h4>Arguments<a class="headerlink" href="#id34" title="Permalink to this
heading">¶</a></h4>
+<section id="id36">
+<h4>Arguments<a class="headerlink" href="#id36" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression1</strong>: Expression to compare and return if equal
to expression2.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -3374,8 +3436,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">ascii</span><span
class="p">(</span><span class="nb">str</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id35">
-<h4>Arguments<a class="headerlink" href="#id35" title="Permalink to this
heading">¶</a></h4>
+<section id="id37">
+<h4>Arguments<a class="headerlink" href="#id37" title="Permalink 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>
@@ -3390,8 +3452,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">bit_length</span><span
class="p">(</span><span class="nb">str</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id36">
-<h4>Arguments<a class="headerlink" href="#id36" title="Permalink to this
heading">¶</a></h4>
+<section id="id38">
+<h4>Arguments<a class="headerlink" href="#id38" title="Permalink 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>
@@ -3409,8 +3471,8 @@ of the input string.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">btrim</span><span
class="p">(</span><span class="nb">str</span><span class="p">[,</span> <span
class="n">trim_str</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id37">
-<h4>Arguments<a class="headerlink" href="#id37" title="Permalink to this
heading">¶</a></h4>
+<section id="id39">
+<h4>Arguments<a class="headerlink" href="#id39" title="Permalink 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>
@@ -3438,8 +3500,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">concat</span><span
class="p">(</span><span class="nb">str</span><span class="p">[,</span> <span
class="o">...</span><span class="p">,</span> <span class="n">str_n</span><span
class="p">])</span>
</pre></div>
</div>
-<section id="id38">
-<h4>Arguments<a class="headerlink" href="#id38" title="Permalink to this
heading">¶</a></h4>
+<section id="id40">
+<h4>Arguments<a class="headerlink" href="#id40" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to concatenate.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -3455,8 +3517,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">concat</span><span
class="p">(</span><span class="n">separator</span><span class="p">,</span>
<span class="nb">str</span><span class="p">[,</span> <span
class="o">...</span><span class="p">,</span> <span class="n">str_n</span><span
class="p">])</span>
</pre></div>
</div>
-<section id="id39">
-<h4>Arguments<a class="headerlink" href="#id39" title="Permalink to this
heading">¶</a></h4>
+<section id="id41">
+<h4>Arguments<a class="headerlink" href="#id41" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>separator</strong>: Separator to insert between concatenated
strings.</p></li>
<li><p><strong>str</strong>: String expression to concatenate.
@@ -3473,8 +3535,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="nb">chr</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id40">
-<h4>Arguments<a class="headerlink" href="#id40" title="Permalink to this
heading">¶</a></h4>
+<section id="id42">
+<h4>Arguments<a class="headerlink" href="#id42" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression containing the ASCII or Unicode
code value to operate on.
Can be a constant, column, or function, and any combination of arithmetic or
@@ -3491,8 +3553,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="id41">
-<h4>Arguments<a class="headerlink" href="#id41" title="Permalink to this
heading">¶</a></h4>
+<section id="id43">
+<h4>Arguments<a class="headerlink" href="#id43" title="Permalink 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>
@@ -3508,8 +3570,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">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="id42">
-<h4>Arguments<a class="headerlink" href="#id42" title="Permalink to this
heading">¶</a></h4>
+<section id="id44">
+<h4>Arguments<a class="headerlink" href="#id44" title="Permalink 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>
@@ -3525,15 +3587,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="id43">
-<h4>Arguments<a class="headerlink" href="#id43" title="Permalink to this
heading">¶</a></h4>
+<section id="id45">
+<h4>Arguments<a class="headerlink" href="#id45" title="Permalink 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="id44">
-<h4>Aliases<a class="headerlink" href="#id44" title="Permalink to this
heading">¶</a></h4>
+<section id="id46">
+<h4>Aliases<a class="headerlink" href="#id46" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>char_length</p></li>
<li><p>character_length</p></li>
@@ -3549,8 +3611,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="id45">
-<h4>Arguments<a class="headerlink" href="#id45" title="Permalink to this
heading">¶</a></h4>
+<section id="id47">
+<h4>Arguments<a class="headerlink" href="#id47" title="Permalink 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>
@@ -3566,8 +3628,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="id46">
-<h4>Arguments<a class="headerlink" href="#id46" title="Permalink to this
heading">¶</a></h4>
+<section id="id48">
+<h4>Arguments<a class="headerlink" href="#id48" title="Permalink 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>
@@ -3586,8 +3648,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="id47">
-<h4>Arguments<a class="headerlink" href="#id47" title="Permalink to this
heading">¶</a></h4>
+<section id="id49">
+<h4>Arguments<a class="headerlink" href="#id49" title="Permalink 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>
@@ -3597,8 +3659,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="id48">
-<h4>Arguments<a class="headerlink" href="#id48" title="Permalink to this
heading">¶</a></h4>
+<section id="id50">
+<h4>Arguments<a class="headerlink" href="#id50" title="Permalink 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>
@@ -3611,8 +3673,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="id49">
-<h4>Arguments<a class="headerlink" href="#id49" title="Permalink to this
heading">¶</a></h4>
+<section id="id51">
+<h4>Arguments<a class="headerlink" href="#id51" title="Permalink 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>
@@ -3628,8 +3690,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="id50">
-<h4>Arguments<a class="headerlink" href="#id50" title="Permalink to this
heading">¶</a></h4>
+<section id="id52">
+<h4>Arguments<a class="headerlink" href="#id52" title="Permalink 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>
@@ -3643,8 +3705,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="id51">
-<h4>Arguments<a class="headerlink" href="#id51" title="Permalink to this
heading">¶</a></h4>
+<section id="id53">
+<h4>Arguments<a class="headerlink" href="#id53" title="Permalink 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>
@@ -3661,8 +3723,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="id52">
-<h4>Arguments<a class="headerlink" href="#id52" title="Permalink to this
heading">¶</a></h4>
+<section id="id54">
+<h4>Arguments<a class="headerlink" href="#id54" title="Permalink 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>
@@ -3675,8 +3737,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="id53">
-<h4>Arguments<a class="headerlink" href="#id53" title="Permalink to this
heading">¶</a></h4>
+<section id="id55">
+<h4>Arguments<a class="headerlink" href="#id55" title="Permalink 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>
@@ -3692,8 +3754,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="id54">
-<h4>Arguments<a class="headerlink" href="#id54" title="Permalink to this
heading">¶</a></h4>
+<section id="id56">
+<h4>Arguments<a class="headerlink" href="#id56" title="Permalink 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>
@@ -3712,8 +3774,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="id55">
-<h4>Arguments<a class="headerlink" href="#id55" title="Permalink to this
heading">¶</a></h4>
+<section id="id57">
+<h4>Arguments<a class="headerlink" href="#id57" title="Permalink 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>
@@ -3731,8 +3793,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="id56">
-<h4>Arguments<a class="headerlink" href="#id56" title="Permalink to this
heading">¶</a></h4>
+<section id="id58">
+<h4>Arguments<a class="headerlink" href="#id58" title="Permalink 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>
@@ -3747,8 +3809,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="id57">
-<h4>Arguments<a class="headerlink" href="#id57" title="Permalink to this
heading">¶</a></h4>
+<section id="id59">
+<h4>Arguments<a class="headerlink" href="#id59" title="Permalink 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>
@@ -3764,8 +3826,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="id58">
-<h4>Arguments<a class="headerlink" href="#id58" title="Permalink to this
heading">¶</a></h4>
+<section id="id60">
+<h4>Arguments<a class="headerlink" href="#id60" title="Permalink 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>
@@ -3781,8 +3843,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="id59">
-<h4>Arguments<a class="headerlink" href="#id59" title="Permalink to this
heading">¶</a></h4>
+<section id="id61">
+<h4>Arguments<a class="headerlink" href="#id61" title="Permalink 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>
@@ -3813,8 +3875,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="id60">
-<h4>Arguments<a class="headerlink" href="#id60" title="Permalink to this
heading">¶</a></h4>
+<section id="id62">
+<h4>Arguments<a class="headerlink" href="#id62" title="Permalink 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>
@@ -3827,8 +3889,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="id61">
-<h4>Arguments<a class="headerlink" href="#id61" title="Permalink to this
heading">¶</a></h4>
+<section id="id63">
+<h4>Arguments<a class="headerlink" href="#id63" title="Permalink 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>
@@ -3845,8 +3907,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="id62">
-<h4>Arguments<a class="headerlink" href="#id62" title="Permalink to this
heading">¶</a></h4>
+<section id="id64">
+<h4>Arguments<a class="headerlink" href="#id64" title="Permalink 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>
@@ -3876,8 +3938,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">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="id63">
-<h4>Arguments<a class="headerlink" href="#id63" title="Permalink to this
heading">¶</a></h4>
+<section id="id65">
+<h4>Arguments<a class="headerlink" href="#id65" title="Permalink 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>
@@ -3892,8 +3954,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">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="id64">
-<h4>Arguments<a class="headerlink" href="#id64" title="Permalink to this
heading">¶</a></h4>
+<section id="id66">
+<h4>Arguments<a class="headerlink" href="#id66" title="Permalink 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>
@@ -3917,8 +3979,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="id65">
-<h4>Arguments<a class="headerlink" href="#id65" title="Permalink to this
heading">¶</a></h4>
+<section id="id67">
+<h4>Arguments<a class="headerlink" href="#id67" title="Permalink 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>
@@ -3933,8 +3995,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="id66">
-<h4>Arguments<a class="headerlink" href="#id66" title="Permalink to this
heading">¶</a></h4>
+<section id="id68">
+<h4>Arguments<a class="headerlink" href="#id68" title="Permalink 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>
@@ -4009,8 +4071,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="id67">
-<h4>Arguments<a class="headerlink" href="#id67" title="Permalink to this
heading">¶</a></h4>
+<section id="id69">
+<h4>Arguments<a class="headerlink" href="#id69" title="Permalink 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.
@@ -4039,8 +4101,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_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="id68">
-<h4>Arguments<a class="headerlink" href="#id68" title="Permalink to this
heading">¶</a></h4>
+<section id="id70">
+<h4>Arguments<a class="headerlink" href="#id70" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>precision</strong>: Time precision to truncate to.
The following precisions are supported:</p>
@@ -4059,8 +4121,8 @@ The following precisions are supported:</p>
Can be a constant, column, or function.</p></li>
</ul>
</section>
-<section id="id69">
-<h4>Aliases<a class="headerlink" href="#id69" title="Permalink to this
heading">¶</a></h4>
+<section id="id71">
+<h4>Aliases<a class="headerlink" href="#id71" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>datetrunc</p></li>
</ul>
@@ -4076,8 +4138,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="id70">
-<h4>Arguments<a class="headerlink" href="#id70" title="Permalink to this
heading">¶</a></h4>
+<section id="id72">
+<h4>Arguments<a class="headerlink" href="#id72" title="Permalink 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>
@@ -4100,8 +4162,8 @@ The following date parts are supported:</p>
Can be a constant, column, or function.</p></li>
</ul>
</section>
-<section id="id71">
-<h4>Aliases<a class="headerlink" href="#id71" title="Permalink to this
heading">¶</a></h4>
+<section id="id73">
+<h4>Aliases<a class="headerlink" href="#id73" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>datepart</p></li>
</ul>
@@ -4118,8 +4180,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="id72">
-<h4>Arguments<a class="headerlink" href="#id72" title="Permalink to this
heading">¶</a></h4>
+<section id="id74">
+<h4>Arguments<a class="headerlink" href="#id74" title="Permalink 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>
@@ -4152,8 +4214,8 @@ return the corresponding RFC3339 nanosecond timestamp.</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>
</pre></div>
</div>
-<section id="id73">
-<h4>Arguments<a class="headerlink" href="#id73" title="Permalink to this
heading">¶</a></h4>
+<section id="id75">
+<h4>Arguments<a class="headerlink" href="#id75" title="Permalink 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>
@@ -4169,8 +4231,8 @@ return the corresponding RFC3339 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>
</pre></div>
</div>
-<section id="id74">
-<h4>Arguments<a class="headerlink" href="#id74" title="Permalink to this
heading">¶</a></h4>
+<section id="id76">
+<h4>Arguments<a class="headerlink" href="#id76" title="Permalink 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>
@@ -4186,8 +4248,8 @@ return the corresponding RFC3339 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>
</pre></div>
</div>
-<section id="id75">
-<h4>Arguments<a class="headerlink" href="#id75" title="Permalink to this
heading">¶</a></h4>
+<section id="id77">
+<h4>Arguments<a class="headerlink" href="#id77" title="Permalink 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>
@@ -4203,8 +4265,8 @@ return the corresponding RFC3339 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>
</pre></div>
</div>
-<section id="id76">
-<h4>Arguments<a class="headerlink" href="#id76" title="Permalink to this
heading">¶</a></h4>
+<section id="id78">
+<h4>Arguments<a class="headerlink" href="#id78" title="Permalink 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>
@@ -4219,8 +4281,8 @@ RFC3339 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="id77">
-<h4>Arguments<a class="headerlink" href="#id77" title="Permalink to this
heading">¶</a></h4>
+<section id="id79">
+<h4>Arguments<a class="headerlink" href="#id79" title="Permalink 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>
@@ -4291,8 +4353,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="id78">
-<h4>Arguments<a class="headerlink" href="#id78" title="Permalink to this
heading">¶</a></h4>
+<section id="id80">
+<h4>Arguments<a class="headerlink" href="#id80" title="Permalink 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>
@@ -4310,8 +4372,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id79">
-<h4>Aliases<a class="headerlink" href="#id79" title="Permalink to this
heading">¶</a></h4>
+<section id="id81">
+<h4>Aliases<a class="headerlink" href="#id81" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>array_push_back</p></li>
<li><p>list_append</p></li>
@@ -4329,16 +4391,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="id80">
-<h4>Arguments<a class="headerlink" href="#id80" title="Permalink to this
heading">¶</a></h4>
+<section id="id82">
+<h4>Arguments<a class="headerlink" href="#id82" title="Permalink 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="id81">
-<h4>Example<a class="headerlink" href="#id81" title="Permalink to this
heading">¶</a></h4>
+<section id="id83">
+<h4>Example<a class="headerlink" href="#id83" title="Permalink 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])) |
@@ -4348,8 +4410,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id82">
-<h4>Aliases<a class="headerlink" href="#id82" title="Permalink to this
heading">¶</a></h4>
+<section id="id84">
+<h4>Aliases<a class="headerlink" href="#id84" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>array_cat</p></li>
<li><p>list_cat</p></li>
@@ -4363,8 +4425,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="id83">
-<h4>Arguments<a class="headerlink" href="#id83" title="Permalink to this
heading">¶</a></h4>
+<section id="id85">
+<h4>Arguments<a class="headerlink" href="#id85" title="Permalink 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>
@@ -4379,8 +4441,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="id84">
-<h4>Arguments<a class="headerlink" href="#id84" title="Permalink to this
heading">¶</a></h4>
+<section id="id86">
+<h4>Arguments<a class="headerlink" href="#id86" title="Permalink 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>
@@ -4395,8 +4457,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="id85">
-<h4>Arguments<a class="headerlink" href="#id85" title="Permalink to this
heading">¶</a></h4>
+<section id="id87">
+<h4>Arguments<a class="headerlink" href="#id87" title="Permalink 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>
@@ -4411,15 +4473,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="id86">
-<h4>Arguments<a class="headerlink" href="#id86" title="Permalink to this
heading">¶</a></h4>
+<section id="id88">
+<h4>Arguments<a class="headerlink" href="#id88" title="Permalink 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="id87">
-<h4>Example<a class="headerlink" href="#id87" title="Permalink to this
heading">¶</a></h4>
+<section id="id89">
+<h4>Example<a class="headerlink" href="#id89" title="Permalink 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])) |
@@ -4429,8 +4491,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id88">
-<h4>Aliases<a class="headerlink" href="#id88" title="Permalink to this
heading">¶</a></h4>
+<section id="id90">
+<h4>Aliases<a class="headerlink" href="#id90" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_dims</p></li>
</ul>
@@ -4442,16 +4504,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="id89">
-<h4>Arguments<a class="headerlink" href="#id89" title="Permalink to this
heading">¶</a></h4>
+<section id="id91">
+<h4>Arguments<a class="headerlink" href="#id91" title="Permalink 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="id90">
-<h4>Example<a class="headerlink" href="#id90" title="Permalink to this
heading">¶</a></h4>
+<section id="id92">
+<h4>Example<a class="headerlink" href="#id92" title="Permalink 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)) |
@@ -4461,8 +4523,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id91">
-<h4>Aliases<a class="headerlink" href="#id91" title="Permalink to this
heading">¶</a></h4>
+<section id="id93">
+<h4>Aliases<a class="headerlink" href="#id93" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>array_extract</p></li>
<li><p>list_element</p></li>
@@ -4481,8 +4543,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="id92">
-<h4>Arguments<a class="headerlink" href="#id92" title="Permalink to this
heading">¶</a></h4>
+<section id="id94">
+<h4>Arguments<a class="headerlink" href="#id94" title="Permalink 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>
@@ -4498,8 +4560,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="id93">
-<h4>Arguments<a class="headerlink" href="#id93" title="Permalink to this
heading">¶</a></h4>
+<section id="id95">
+<h4>Arguments<a class="headerlink" href="#id95" title="Permalink 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>
@@ -4523,16 +4585,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="id94">
-<h4>Arguments<a class="headerlink" href="#id94" title="Permalink to this
heading">¶</a></h4>
+<section id="id96">
+<h4>Arguments<a class="headerlink" href="#id96" title="Permalink 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="id95">
-<h4>Example<a class="headerlink" href="#id95" title="Permalink to this
heading">¶</a></h4>
+<section id="id97">
+<h4>Example<a class="headerlink" href="#id97" title="Permalink 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])) |
@@ -4542,8 +4604,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id96">
-<h4>Aliases<a class="headerlink" href="#id96" title="Permalink to this
heading">¶</a></h4>
+<section id="id98">
+<h4>Aliases<a class="headerlink" href="#id98" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_length</p></li>
</ul>
@@ -4555,15 +4617,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="id97">
-<h4>Arguments<a class="headerlink" href="#id97" title="Permalink to this
heading">¶</a></h4>
+<section id="id99">
+<h4>Arguments<a class="headerlink" href="#id99" title="Permalink 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="Permalink to this
heading">¶</a></h4>
+<section id="id100">
+<h4>Example<a class="headerlink" href="#id100" title="Permalink 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])) |
@@ -4573,8 +4635,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="Permalink to this
heading">¶</a></h4>
+<section id="id101">
+<h4>Aliases<a class="headerlink" href="#id101" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_ndims</p></li>
</ul>
@@ -4586,16 +4648,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="id100">
-<h4>Arguments<a class="headerlink" href="#id100" title="Permalink to this
heading">¶</a></h4>
+<section id="id102">
+<h4>Arguments<a class="headerlink" href="#id102" title="Permalink 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="id101">
-<h4>Example<a class="headerlink" href="#id101" title="Permalink to this
heading">¶</a></h4>
+<section id="id103">
+<h4>Example<a class="headerlink" href="#id103" title="Permalink 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])) |
@@ -4605,8 +4667,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="Permalink to this
heading">¶</a></h4>
+<section id="id104">
+<h4>Aliases<a class="headerlink" href="#id104" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>array_push_front</p></li>
<li><p>list_prepend</p></li>
@@ -4621,8 +4683,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="id103">
-<h4>Arguments<a class="headerlink" href="#id103" title="Permalink to this
heading">¶</a></h4>
+<section id="id105">
+<h4>Arguments<a class="headerlink" href="#id105" title="Permalink 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>
@@ -4630,8 +4692,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="id104">
-<h4>Example<a class="headerlink" href="#id104" title="Permalink to this
heading">¶</a></h4>
+<section id="id106">
+<h4>Example<a class="headerlink" href="#id106" title="Permalink 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)) |
@@ -4641,8 +4703,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id105">
-<h4>Aliases<a class="headerlink" href="#id105" title="Permalink to this
heading">¶</a></h4>
+<section id="id107">
+<h4>Aliases<a class="headerlink" href="#id107" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>array_indexof</p></li>
<li><p>list_indexof</p></li>
@@ -4656,16 +4718,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="id106">
-<h4>Arguments<a class="headerlink" href="#id106" title="Permalink to this
heading">¶</a></h4>
+<section id="id108">
+<h4>Arguments<a class="headerlink" href="#id108" title="Permalink 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="id107">
-<h4>Example<a class="headerlink" href="#id107" title="Permalink to this
heading">¶</a></h4>
+<section id="id109">
+<h4>Example<a class="headerlink" href="#id109" title="Permalink 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)) |
@@ -4675,8 +4737,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id108">
-<h4>Aliases<a class="headerlink" href="#id108" title="Permalink to this
heading">¶</a></h4>
+<section id="id110">
+<h4>Aliases<a class="headerlink" href="#id110" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_positions</p></li>
</ul>
@@ -4696,16 +4758,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="id109">
-<h4>Arguments<a class="headerlink" href="#id109" title="Permalink to this
heading">¶</a></h4>
+<section id="id111">
+<h4>Arguments<a class="headerlink" href="#id111" title="Permalink 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="id110">
-<h4>Example<a class="headerlink" href="#id110" title="Permalink to this
heading">¶</a></h4>
+<section id="id112">
+<h4>Example<a class="headerlink" href="#id112" title="Permalink 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)) |
@@ -4730,16 +4792,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="id111">
-<h4>Arguments<a class="headerlink" href="#id111" title="Permalink to this
heading">¶</a></h4>
+<section id="id113">
+<h4>Arguments<a class="headerlink" href="#id113" title="Permalink 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="id112">
-<h4>Example<a class="headerlink" href="#id112" title="Permalink to this
heading">¶</a></h4>
+<section id="id114">
+<h4>Example<a class="headerlink" href="#id114" title="Permalink 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)) |
@@ -4749,8 +4811,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="Permalink to this
heading">¶</a></h4>
+<section id="id115">
+<h4>Aliases<a class="headerlink" href="#id115" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_remove</p></li>
</ul>
@@ -4762,8 +4824,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="id114">
-<h4>Arguments<a class="headerlink" href="#id114" title="Permalink to this
heading">¶</a></h4>
+<section id="id116">
+<h4>Arguments<a class="headerlink" href="#id116" title="Permalink 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>
@@ -4771,8 +4833,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="id115">
-<h4>Example<a class="headerlink" href="#id115" title="Permalink to this
heading">¶</a></h4>
+<section id="id117">
+<h4>Example<a class="headerlink" href="#id117" title="Permalink 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)) |
@@ -4782,8 +4844,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id116">
-<h4>Aliases<a class="headerlink" href="#id116" title="Permalink to this
heading">¶</a></h4>
+<section id="id118">
+<h4>Aliases<a class="headerlink" href="#id118" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_remove_n</p></li>
</ul>
@@ -4795,16 +4857,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="id117">
-<h4>Arguments<a class="headerlink" href="#id117" title="Permalink to this
heading">¶</a></h4>
+<section id="id119">
+<h4>Arguments<a class="headerlink" href="#id119" title="Permalink 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="id118">
-<h4>Example<a class="headerlink" href="#id118" title="Permalink to this
heading">¶</a></h4>
+<section id="id120">
+<h4>Example<a class="headerlink" href="#id120" title="Permalink 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)) |
@@ -4814,8 +4876,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id119">
-<h4>Aliases<a class="headerlink" href="#id119" title="Permalink to this
heading">¶</a></h4>
+<section id="id121">
+<h4>Aliases<a class="headerlink" href="#id121" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_remove_all</p></li>
</ul>
@@ -4827,8 +4889,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="id120">
-<h4>Arguments<a class="headerlink" href="#id120" title="Permalink to this
heading">¶</a></h4>
+<section id="id122">
+<h4>Arguments<a class="headerlink" href="#id122" title="Permalink 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>
@@ -4836,8 +4898,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="id121">
-<h4>Example<a class="headerlink" href="#id121" title="Permalink to this
heading">¶</a></h4>
+<section id="id123">
+<h4>Example<a class="headerlink" href="#id123" title="Permalink 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)) |
@@ -4847,8 +4909,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id122">
-<h4>Aliases<a class="headerlink" href="#id122" title="Permalink to this
heading">¶</a></h4>
+<section id="id124">
+<h4>Aliases<a class="headerlink" href="#id124" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_replace</p></li>
</ul>
@@ -4860,8 +4922,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="id123">
-<h4>Arguments<a class="headerlink" href="#id123" title="Permalink to this
heading">¶</a></h4>
+<section id="id125">
+<h4>Arguments<a class="headerlink" href="#id125" title="Permalink 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>
@@ -4870,8 +4932,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="id124">
-<h4>Example<a class="headerlink" href="#id124" title="Permalink to this
heading">¶</a></h4>
+<section id="id126">
+<h4>Example<a class="headerlink" href="#id126" title="Permalink 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)) |
@@ -4881,8 +4943,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id125">
-<h4>Aliases<a class="headerlink" href="#id125" title="Permalink to this
heading">¶</a></h4>
+<section id="id127">
+<h4>Aliases<a class="headerlink" href="#id127" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_replace_n</p></li>
</ul>
@@ -4894,8 +4956,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="id126">
-<h4>Arguments<a class="headerlink" href="#id126" title="Permalink to this
heading">¶</a></h4>
+<section id="id128">
+<h4>Arguments<a class="headerlink" href="#id128" title="Permalink 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>
@@ -4903,8 +4965,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="id127">
-<h4>Example<a class="headerlink" href="#id127" title="Permalink to this
heading">¶</a></h4>
+<section id="id129">
+<h4>Example<a class="headerlink" href="#id129" title="Permalink 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)) |
@@ -4914,8 +4976,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="Permalink to this
heading">¶</a></h4>
+<section id="id130">
+<h4>Aliases<a class="headerlink" href="#id130" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_replace_all</p></li>
</ul>
@@ -4927,8 +4989,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="id129">
-<h4>Example<a class="headerlink" href="#id129" title="Permalink to this
heading">¶</a></h4>
+<section id="id131">
+<h4>Example<a class="headerlink" href="#id131" title="Permalink 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)) |
@@ -4938,8 +5000,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id130">
-<h4>Aliases<a class="headerlink" href="#id130" title="Permalink to this
heading">¶</a></h4>
+<section id="id132">
+<h4>Aliases<a class="headerlink" href="#id132" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_slice</p></li>
</ul>
@@ -4951,16 +5013,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">delimeter</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id131">
-<h4>Arguments<a class="headerlink" href="#id131" title="Permalink to this
heading">¶</a></h4>
+<section id="id133">
+<h4>Arguments<a class="headerlink" href="#id133" title="Permalink 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>delimeter</strong>: Array element separator.</p></li>
</ul>
</section>
-<section id="id132">
-<h4>Example<a class="headerlink" href="#id132" title="Permalink to this
heading">¶</a></h4>
+<section id="id134">
+<h4>Example<a class="headerlink" href="#id134" title="Permalink 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(",")) |
@@ -4970,8 +5032,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id133">
-<h4>Aliases<a class="headerlink" href="#id133" title="Permalink to this
heading">¶</a></h4>
+<section id="id135">
+<h4>Aliases<a class="headerlink" href="#id135" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>array_join</p></li>
<li><p>list_join</p></li>
@@ -4985,15 +5047,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="id134">
-<h4>Arguments<a class="headerlink" href="#id134" title="Permalink to this
heading">¶</a></h4>
+<section id="id136">
+<h4>Arguments<a class="headerlink" href="#id136" title="Permalink 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="id135">
-<h4>Example<a class="headerlink" href="#id135" title="Permalink to this
heading">¶</a></h4>
+<section id="id137">
+<h4>Example<a class="headerlink" href="#id137" title="Permalink 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])) |
@@ -5106,16 +5168,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="id136">
-<h4>Arguments<a class="headerlink" href="#id136" title="Permalink to this
heading">¶</a></h4>
+<section id="id138">
+<h4>Arguments<a class="headerlink" href="#id138" title="Permalink 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="id137">
-<h4>Example<a class="headerlink" href="#id137" title="Permalink to this
heading">¶</a></h4>
+<section id="id139">
+<h4>Example<a class="headerlink" href="#id139" title="Permalink 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)) |
@@ -5125,8 +5187,8 @@ string operators.</p></li>
</pre></div>
</div>
</section>
-<section id="id138">
-<h4>Aliases<a class="headerlink" href="#id138" title="Permalink to this
heading">¶</a></h4>
+<section id="id140">
+<h4>Aliases<a class="headerlink" href="#id140" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>make_list</p></li>
</ul>
@@ -5143,8 +5205,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="id139">
-<h4>Arguments<a class="headerlink" href="#id139" title="Permalink to this
heading">¶</a></h4>
+<section id="id141">
+<h4>Arguments<a class="headerlink" href="#id141" title="Permalink 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>
@@ -5185,8 +5247,8 @@ a struct type of fields <code class="docutils literal
notranslate"><span class="
+-----------------+
</pre></div>
</div>
-<section id="id140">
-<h4>Arguments<a class="headerlink" href="#id140" title="Permalink to this
heading">¶</a></h4>
+<section id="id142">
+<h4>Arguments<a class="headerlink" href="#id142" title="Permalink 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
@@ -5211,8 +5273,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="id141">
-<h4>Arguments<a class="headerlink" href="#id141" title="Permalink to this
heading">¶</a></h4>
+<section id="id143">
+<h4>Arguments<a class="headerlink" href="#id143" title="Permalink 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>
@@ -5238,8 +5300,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="id142">
-<h4>Arguments<a class="headerlink" href="#id142" title="Permalink to this
heading">¶</a></h4>
+<section id="id144">
+<h4>Arguments<a class="headerlink" href="#id144" title="Permalink 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>
@@ -5252,8 +5314,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="id143">
-<h4>Arguments<a class="headerlink" href="#id143" title="Permalink to this
heading">¶</a></h4>
+<section id="id145">
+<h4>Arguments<a class="headerlink" href="#id145" title="Permalink 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>
@@ -5266,8 +5328,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="id144">
-<h4>Arguments<a class="headerlink" href="#id144" title="Permalink to this
heading">¶</a></h4>
+<section id="id146">
+<h4>Arguments<a class="headerlink" href="#id146" title="Permalink 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>
@@ -5280,8 +5342,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="id145">
-<h4>Arguments<a class="headerlink" href="#id145" title="Permalink to this
heading">¶</a></h4>
+<section id="id147">
+<h4>Arguments<a class="headerlink" href="#id147" title="Permalink 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>
@@ -5294,8 +5356,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="id146">
-<h4>Arguments<a class="headerlink" href="#id146" title="Permalink to this
heading">¶</a></h4>
+<section id="id148">
+<h4>Arguments<a class="headerlink" href="#id148" title="Permalink 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>
@@ -5315,8 +5377,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="id147">
-<h4>Arguments<a class="headerlink" href="#id147" title="Permalink to this
heading">¶</a></h4>
+<section id="id149">
+<h4>Arguments<a class="headerlink" href="#id149" title="Permalink 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
@@ -5332,8 +5394,8 @@ to cast to.</p></li>
<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="id148">
-<h4>Arguments<a class="headerlink" href="#id148" title="Permalink to this
heading">¶</a></h4>
+<section id="id150">
+<h4>Arguments<a class="headerlink" href="#id150" title="Permalink 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
