You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@datafusion.apache.org by gi...@apache.org on 2024/10/29 11:23:36 UTC
(datafusion) branch asf-site updated: Publish built docs triggered by feeb32ab090fda25b9c0aca8b86cf10a5b91acaa
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/datafusion.git
The following commit(s) were added to refs/heads/asf-site by this push:
new 0c300caa9d Publish built docs triggered by feeb32ab090fda25b9c0aca8b86cf10a5b91acaa
0c300caa9d is described below
commit 0c300caa9dd46e14bc4270176bbf2f67926282ba
Author: github-actions[bot] <gi...@users.noreply.github.com>
AuthorDate: Tue Oct 29 11:23:31 2024 +0000
Publish built docs triggered by feeb32ab090fda25b9c0aca8b86cf10a5b91acaa
---
.../user-guide/sql/scalar_functions_new.md.txt | 34 +
searchindex.js | 2 +-
user-guide/sql/scalar_functions_new.html | 1368 ++++++++++----------
3 files changed, 748 insertions(+), 656 deletions(-)
diff --git a/_sources/user-guide/sql/scalar_functions_new.md.txt b/_sources/user-guide/sql/scalar_functions_new.md.txt
index 6031a68d40..56173b97b4 100644
--- a/_sources/user-guide/sql/scalar_functions_new.md.txt
+++ b/_sources/user-guide/sql/scalar_functions_new.md.txt
@@ -808,6 +808,16 @@ btrim(str[, trim_str])
+-------------------------------------------+
```
+#### Alternative Syntax
+
+```sql
+trim(BOTH trim_str FROM str)
+```
+
+```sql
+trim(trim_str FROM str)
+```
+
#### Aliases
- trim
@@ -1191,6 +1201,12 @@ ltrim(str[, trim_str])
+-------------------------------------------+
```
+#### Alternative Syntax
+
+```sql
+trim(LEADING trim_str FROM str)
+```
+
**Related functions**:
- [btrim](#btrim)
@@ -1387,6 +1403,12 @@ rtrim(str[, trim_str])
+-------------------------------------------+
```
+#### Alternative Syntax
+
+```sql
+trim(TRAILING trim_str FROM str)
+```
+
**Related functions**:
- [btrim](#btrim)
@@ -1501,6 +1523,12 @@ substr(str, start_pos[, length])
+----------------------------------------------+
```
+#### Alternative Syntax
+
+```sql
+substring(str from start_pos for length)
+```
+
#### Aliases
- substring
@@ -1965,6 +1993,12 @@ date_part(part, expression)
- **expression**: Time expression to operate on. Can be a constant, column, or function.
+#### Alternative Syntax
+
+```sql
+extract(field FROM source)
+```
+
#### Aliases
- datepart
diff --git a/searchindex.js b/searchindex.js
index ee077b74bc..e0e2a101b6 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"alltitles": {"!=": [[48, "op-neq"]], "!~": [[48, "op-re-not-match"]], "!~*": [[48, "op-re-not-match-i"]], "!~~": [[48, "id18"]], "!~~*": [[48, "id19"]], "#": [[48, "op-bit-xor"]], "%": [[48, "op-modulo"]], "&": [[48, "op-bit-and"]], "(relation, name) tuples in logical fields and logical columns are unique": [[9, "relation-name-tuples-in-logical-fields-and-logical-columns-are-unique"]], "*": [[48, "op-multiply"]], "+": [[48, "op-plus"]], "-": [[48, "op-minus"]], "/": [[4 [...]
\ No newline at end of file
+Search.setIndex({"alltitles": {"!=": [[48, "op-neq"]], "!~": [[48, "op-re-not-match"]], "!~*": [[48, "op-re-not-match-i"]], "!~~": [[48, "id18"]], "!~~*": [[48, "id19"]], "#": [[48, "op-bit-xor"]], "%": [[48, "op-modulo"]], "&": [[48, "op-bit-and"]], "(relation, name) tuples in logical fields and logical columns are unique": [[9, "relation-name-tuples-in-logical-fields-and-logical-columns-are-unique"]], "*": [[48, "op-multiply"]], "+": [[48, "op-plus"]], "-": [[48, "op-minus"]], "/": [[4 [...]
\ No newline at end of file
diff --git a/user-guide/sql/scalar_functions_new.html b/user-guide/sql/scalar_functions_new.html
index 0bc6a28f06..f521bfa38c 100644
--- a/user-guide/sql/scalar_functions_new.html
+++ b/user-guide/sql/scalar_functions_new.html
@@ -1299,6 +1299,11 @@
Example
</a>
</li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#alternative-syntax">
+ Alternative Syntax
+ </a>
+ </li>
<li class="toc-h4 nav-item toc-entry">
<a class="reference internal nav-link" href="#id50">
Aliases
@@ -1609,6 +1614,11 @@
Example
</a>
</li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id78">
+ Alternative Syntax
+ </a>
+ </li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
@@ -1621,12 +1631,12 @@
</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="#id79">
Arguments
</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="#id80">
Example
</a>
</li>
@@ -1651,12 +1661,12 @@
</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="#id81">
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="#id82">
Example
</a>
</li>
@@ -1672,12 +1682,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id82">
+ <a class="reference internal nav-link" href="#id83">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id83">
+ <a class="reference internal nav-link" href="#id84">
Example
</a>
</li>
@@ -1693,12 +1703,12 @@
</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="#id85">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id85">
+ <a class="reference internal nav-link" href="#id86">
Example
</a>
</li>
@@ -1714,12 +1724,12 @@
</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="#id87">
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="#id88">
Example
</a>
</li>
@@ -1735,12 +1745,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id88">
+ <a class="reference internal nav-link" href="#id89">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id89">
+ <a class="reference internal nav-link" href="#id90">
Example
</a>
</li>
@@ -1756,15 +1766,20 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id90">
+ <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="#id91">
+ <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="#id93">
+ Alternative Syntax
+ </a>
+ </li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
@@ -1777,12 +1792,12 @@
</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>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id93">
+ <a class="reference internal nav-link" href="#id95">
Example
</a>
</li>
@@ -1798,12 +1813,12 @@
</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>
@@ -1819,22 +1834,22 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id96">
+ <a class="reference internal nav-link" href="#id98">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id97">
+ <a class="reference internal nav-link" href="#id99">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#alternative-syntax">
+ <a class="reference internal nav-link" href="#id100">
Alternative Syntax
</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="#id101">
Aliases
</a>
</li>
@@ -1850,17 +1865,22 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id99">
+ <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="#id100">
+ <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="#id101">
+ <a class="reference internal nav-link" href="#id104">
+ Alternative Syntax
+ </a>
+ </li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id105">
Aliases
</a>
</li>
@@ -1876,17 +1896,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id102">
+ <a class="reference internal nav-link" href="#id106">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id103">
+ <a class="reference internal nav-link" href="#id107">
Example
</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="#id108">
Aliases
</a>
</li>
@@ -1920,12 +1940,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id105">
+ <a class="reference internal nav-link" href="#id109">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id106">
+ <a class="reference internal nav-link" href="#id110">
Example
</a>
</li>
@@ -1941,12 +1961,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id107">
+ <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="#id108">
+ <a class="reference internal nav-link" href="#id112">
Example
</a>
</li>
@@ -1971,12 +1991,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="#id113">
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="#id114">
Example
</a>
</li>
@@ -1992,7 +2012,7 @@
</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="#id115">
Example
</a>
</li>
@@ -2015,7 +2035,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id112">
+ <a class="reference internal nav-link" href="#id116">
Arguments
</a>
</li>
@@ -2031,7 +2051,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id113">
+ <a class="reference internal nav-link" href="#id117">
Arguments
</a>
</li>
@@ -2054,12 +2074,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id114">
+ <a class="reference internal nav-link" href="#id118">
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="#id119">
Example
</a>
</li>
@@ -2075,12 +2095,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id116">
+ <a class="reference internal nav-link" href="#id120">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id117">
+ <a class="reference internal nav-link" href="#id121">
Example
</a>
</li>
@@ -2096,12 +2116,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id118">
+ <a class="reference internal nav-link" href="#id122">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id119">
+ <a class="reference internal nav-link" href="#id123">
Example
</a>
</li>
@@ -2117,12 +2137,12 @@
</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="#id124">
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="#id125">
Example
</a>
</li>
@@ -2145,7 +2165,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id122">
+ <a class="reference internal nav-link" href="#id126">
Aliases
</a>
</li>
@@ -2179,7 +2199,7 @@
</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="#id127">
Arguments
</a>
</li>
@@ -2204,12 +2224,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id124">
+ <a class="reference internal nav-link" href="#id128">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id125">
+ <a class="reference internal nav-link" href="#id129">
+ Alternative Syntax
+ </a>
+ </li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id130">
Aliases
</a>
</li>
@@ -2225,12 +2250,12 @@
</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="#id131">
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="#id132">
Aliases
</a>
</li>
@@ -2264,7 +2289,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id128">
+ <a class="reference internal nav-link" href="#id133">
Arguments
</a>
</li>
@@ -2280,12 +2305,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="#id134">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id130">
+ <a class="reference internal nav-link" href="#id135">
Example
</a>
</li>
@@ -2301,7 +2326,7 @@
</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="#id136">
Aliases
</a>
</li>
@@ -2317,17 +2342,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id132">
+ <a class="reference internal nav-link" href="#id137">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id133">
+ <a class="reference internal nav-link" href="#id138">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id134">
+ <a class="reference internal nav-link" href="#id139">
Aliases
</a>
</li>
@@ -2343,12 +2368,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id135">
+ <a class="reference internal nav-link" href="#id140">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id136">
+ <a class="reference internal nav-link" href="#id141">
Example
</a>
</li>
@@ -2364,12 +2389,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id137">
+ <a class="reference internal nav-link" href="#id142">
Arguments
</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="#id143">
Example
</a>
</li>
@@ -2385,12 +2410,12 @@
</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="#id144">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id140">
+ <a class="reference internal nav-link" href="#id145">
Example
</a>
</li>
@@ -2406,12 +2431,12 @@
</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="#id146">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id142">
+ <a class="reference internal nav-link" href="#id147">
Example
</a>
</li>
@@ -2427,12 +2452,12 @@
</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="#id148">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id144">
+ <a class="reference internal nav-link" href="#id149">
Example
</a>
</li>
@@ -2448,12 +2473,12 @@
</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="#id150">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id146">
+ <a class="reference internal nav-link" href="#id151">
Example
</a>
</li>
@@ -2469,12 +2494,12 @@
</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="#id152">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id148">
+ <a class="reference internal nav-link" href="#id153">
Example
</a>
</li>
@@ -2490,12 +2515,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id149">
+ <a class="reference internal nav-link" href="#id154">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id150">
+ <a class="reference internal nav-link" href="#id155">
Example
</a>
</li>
@@ -2527,17 +2552,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id151">
+ <a class="reference internal nav-link" href="#id156">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id152">
+ <a class="reference internal nav-link" href="#id157">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id153">
+ <a class="reference internal nav-link" href="#id158">
Aliases
</a>
</li>
@@ -2553,17 +2578,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id154">
+ <a class="reference internal nav-link" href="#id159">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id155">
+ <a class="reference internal nav-link" href="#id160">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id156">
+ <a class="reference internal nav-link" href="#id161">
Aliases
</a>
</li>
@@ -2588,17 +2613,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id157">
+ <a class="reference internal nav-link" href="#id162">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id158">
+ <a class="reference internal nav-link" href="#id163">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id159">
+ <a class="reference internal nav-link" href="#id164">
Aliases
</a>
</li>
@@ -2623,17 +2648,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id160">
+ <a class="reference internal nav-link" href="#id165">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id161">
+ <a class="reference internal nav-link" href="#id166">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id162">
+ <a class="reference internal nav-link" href="#id167">
Aliases
</a>
</li>
@@ -2649,17 +2674,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id163">
+ <a class="reference internal nav-link" href="#id168">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id164">
+ <a class="reference internal nav-link" href="#id169">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id165">
+ <a class="reference internal nav-link" href="#id170">
Aliases
</a>
</li>
@@ -2675,17 +2700,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id166">
+ <a class="reference internal nav-link" href="#id171">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id167">
+ <a class="reference internal nav-link" href="#id172">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id168">
+ <a class="reference internal nav-link" href="#id173">
Aliases
</a>
</li>
@@ -2701,17 +2726,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id169">
+ <a class="reference internal nav-link" href="#id174">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id170">
+ <a class="reference internal nav-link" href="#id175">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id171">
+ <a class="reference internal nav-link" href="#id176">
Aliases
</a>
</li>
@@ -2736,17 +2761,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id172">
+ <a class="reference internal nav-link" href="#id177">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id173">
+ <a class="reference internal nav-link" href="#id178">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id174">
+ <a class="reference internal nav-link" href="#id179">
Aliases
</a>
</li>
@@ -2771,17 +2796,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id175">
+ <a class="reference internal nav-link" href="#id180">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id176">
+ <a class="reference internal nav-link" href="#id181">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id177">
+ <a class="reference internal nav-link" href="#id182">
Aliases
</a>
</li>
@@ -2797,17 +2822,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id178">
+ <a class="reference internal nav-link" href="#id183">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id179">
+ <a class="reference internal nav-link" href="#id184">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id180">
+ <a class="reference internal nav-link" href="#id185">
Aliases
</a>
</li>
@@ -2823,17 +2848,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id181">
+ <a class="reference internal nav-link" href="#id186">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id182">
+ <a class="reference internal nav-link" href="#id187">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id183">
+ <a class="reference internal nav-link" href="#id188">
Aliases
</a>
</li>
@@ -2858,17 +2883,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id184">
+ <a class="reference internal nav-link" href="#id189">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id185">
+ <a class="reference internal nav-link" href="#id190">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id186">
+ <a class="reference internal nav-link" href="#id191">
Aliases
</a>
</li>
@@ -2893,17 +2918,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id187">
+ <a class="reference internal nav-link" href="#id192">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id188">
+ <a class="reference internal nav-link" href="#id193">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id189">
+ <a class="reference internal nav-link" href="#id194">
Aliases
</a>
</li>
@@ -2919,17 +2944,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id190">
+ <a class="reference internal nav-link" href="#id195">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id191">
+ <a class="reference internal nav-link" href="#id196">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id192">
+ <a class="reference internal nav-link" href="#id197">
Aliases
</a>
</li>
@@ -2945,17 +2970,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id193">
+ <a class="reference internal nav-link" href="#id198">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id194">
+ <a class="reference internal nav-link" href="#id199">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id195">
+ <a class="reference internal nav-link" href="#id200">
Aliases
</a>
</li>
@@ -2971,17 +2996,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id196">
+ <a class="reference internal nav-link" href="#id201">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id197">
+ <a class="reference internal nav-link" href="#id202">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id198">
+ <a class="reference internal nav-link" href="#id203">
Aliases
</a>
</li>
@@ -2997,17 +3022,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id199">
+ <a class="reference internal nav-link" href="#id204">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id200">
+ <a class="reference internal nav-link" href="#id205">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id201">
+ <a class="reference internal nav-link" href="#id206">
Aliases
</a>
</li>
@@ -3023,17 +3048,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id202">
+ <a class="reference internal nav-link" href="#id207">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id203">
+ <a class="reference internal nav-link" href="#id208">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id204">
+ <a class="reference internal nav-link" href="#id209">
Aliases
</a>
</li>
@@ -3049,17 +3074,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id205">
+ <a class="reference internal nav-link" href="#id210">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id206">
+ <a class="reference internal nav-link" href="#id211">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id207">
+ <a class="reference internal nav-link" href="#id212">
Aliases
</a>
</li>
@@ -3093,17 +3118,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id208">
+ <a class="reference internal nav-link" href="#id213">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id209">
+ <a class="reference internal nav-link" href="#id214">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id210">
+ <a class="reference internal nav-link" href="#id215">
Aliases
</a>
</li>
@@ -3119,17 +3144,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id211">
+ <a class="reference internal nav-link" href="#id216">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id212">
+ <a class="reference internal nav-link" href="#id217">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id213">
+ <a class="reference internal nav-link" href="#id218">
Aliases
</a>
</li>
@@ -3145,17 +3170,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id214">
+ <a class="reference internal nav-link" href="#id219">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id215">
+ <a class="reference internal nav-link" href="#id220">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id216">
+ <a class="reference internal nav-link" href="#id221">
Aliases
</a>
</li>
@@ -3171,17 +3196,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id217">
+ <a class="reference internal nav-link" href="#id222">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id218">
+ <a class="reference internal nav-link" href="#id223">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id219">
+ <a class="reference internal nav-link" href="#id224">
Aliases
</a>
</li>
@@ -3197,17 +3222,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id220">
+ <a class="reference internal nav-link" href="#id225">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id221">
+ <a class="reference internal nav-link" href="#id226">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id222">
+ <a class="reference internal nav-link" href="#id227">
Aliases
</a>
</li>
@@ -3223,17 +3248,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id223">
+ <a class="reference internal nav-link" href="#id228">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id224">
+ <a class="reference internal nav-link" href="#id229">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id225">
+ <a class="reference internal nav-link" href="#id230">
Aliases
</a>
</li>
@@ -3249,17 +3274,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id226">
+ <a class="reference internal nav-link" href="#id231">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id227">
+ <a class="reference internal nav-link" href="#id232">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id228">
+ <a class="reference internal nav-link" href="#id233">
Aliases
</a>
</li>
@@ -3275,17 +3300,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id229">
+ <a class="reference internal nav-link" href="#id234">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id230">
+ <a class="reference internal nav-link" href="#id235">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id231">
+ <a class="reference internal nav-link" href="#id236">
Aliases
</a>
</li>
@@ -3301,17 +3326,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id232">
+ <a class="reference internal nav-link" href="#id237">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id233">
+ <a class="reference internal nav-link" href="#id238">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id234">
+ <a class="reference internal nav-link" href="#id239">
Aliases
</a>
</li>
@@ -3327,17 +3352,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id235">
+ <a class="reference internal nav-link" href="#id240">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id236">
+ <a class="reference internal nav-link" href="#id241">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id237">
+ <a class="reference internal nav-link" href="#id242">
Aliases
</a>
</li>
@@ -3353,17 +3378,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id238">
+ <a class="reference internal nav-link" href="#id243">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id239">
+ <a class="reference internal nav-link" href="#id244">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id240">
+ <a class="reference internal nav-link" href="#id245">
Aliases
</a>
</li>
@@ -3379,17 +3404,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id241">
+ <a class="reference internal nav-link" href="#id246">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id242">
+ <a class="reference internal nav-link" href="#id247">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id243">
+ <a class="reference internal nav-link" href="#id248">
Aliases
</a>
</li>
@@ -3405,17 +3430,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id244">
+ <a class="reference internal nav-link" href="#id249">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id245">
+ <a class="reference internal nav-link" href="#id250">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id246">
+ <a class="reference internal nav-link" href="#id251">
Aliases
</a>
</li>
@@ -3431,12 +3456,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id247">
+ <a class="reference internal nav-link" href="#id252">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id248">
+ <a class="reference internal nav-link" href="#id253">
Example
</a>
</li>
@@ -3452,17 +3477,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id249">
+ <a class="reference internal nav-link" href="#id254">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id250">
+ <a class="reference internal nav-link" href="#id255">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id251">
+ <a class="reference internal nav-link" href="#id256">
Aliases
</a>
</li>
@@ -3478,12 +3503,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id252">
+ <a class="reference internal nav-link" href="#id257">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id253">
+ <a class="reference internal nav-link" href="#id258">
Example
</a>
</li>
@@ -3499,12 +3524,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id254">
+ <a class="reference internal nav-link" href="#id259">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id255">
+ <a class="reference internal nav-link" href="#id260">
Example
</a>
</li>
@@ -3880,17 +3905,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id256">
+ <a class="reference internal nav-link" href="#id261">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id257">
+ <a class="reference internal nav-link" href="#id262">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id258">
+ <a class="reference internal nav-link" href="#id263">
Aliases
</a>
</li>
@@ -3915,12 +3940,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id259">
+ <a class="reference internal nav-link" href="#id264">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id260">
+ <a class="reference internal nav-link" href="#id265">
Example
</a>
</li>
@@ -3936,17 +3961,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id261">
+ <a class="reference internal nav-link" href="#id266">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id262">
+ <a class="reference internal nav-link" href="#id267">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id263">
+ <a class="reference internal nav-link" href="#id268">
Aliases
</a>
</li>
@@ -3978,12 +4003,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id264">
+ <a class="reference internal nav-link" href="#id269">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id265">
+ <a class="reference internal nav-link" href="#id270">
Example
</a>
</li>
@@ -4008,17 +4033,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id266">
+ <a class="reference internal nav-link" href="#id271">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id267">
+ <a class="reference internal nav-link" href="#id272">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id268">
+ <a class="reference internal nav-link" href="#id273">
Aliases
</a>
</li>
@@ -4050,17 +4075,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id269">
+ <a class="reference internal nav-link" href="#id274">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id270">
+ <a class="reference internal nav-link" href="#id275">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id271">
+ <a class="reference internal nav-link" href="#id276">
Aliases
</a>
</li>
@@ -4076,12 +4101,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id272">
+ <a class="reference internal nav-link" href="#id277">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id273">
+ <a class="reference internal nav-link" href="#id278">
Example
</a>
</li>
@@ -4097,12 +4122,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id274">
+ <a class="reference internal nav-link" href="#id279">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id275">
+ <a class="reference internal nav-link" href="#id280">
Example
</a>
</li>
@@ -4125,12 +4150,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id276">
+ <a class="reference internal nav-link" href="#id281">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id277">
+ <a class="reference internal nav-link" href="#id282">
Example
</a>
</li>
@@ -4146,12 +4171,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id278">
+ <a class="reference internal nav-link" href="#id283">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id279">
+ <a class="reference internal nav-link" href="#id284">
Example
</a>
</li>
@@ -4167,12 +4192,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id280">
+ <a class="reference internal nav-link" href="#id285">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id281">
+ <a class="reference internal nav-link" href="#id286">
Example
</a>
</li>
@@ -4188,12 +4213,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id282">
+ <a class="reference internal nav-link" href="#id287">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id283">
+ <a class="reference internal nav-link" href="#id288">
Example
</a>
</li>
@@ -4209,12 +4234,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id284">
+ <a class="reference internal nav-link" href="#id289">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id285">
+ <a class="reference internal nav-link" href="#id290">
Example
</a>
</li>
@@ -4230,12 +4255,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id286">
+ <a class="reference internal nav-link" href="#id291">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id287">
+ <a class="reference internal nav-link" href="#id292">
Example
</a>
</li>
@@ -4258,12 +4283,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id288">
+ <a class="reference internal nav-link" href="#id293">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id289">
+ <a class="reference internal nav-link" href="#id294">
Example
</a>
</li>
@@ -4279,12 +4304,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id290">
+ <a class="reference internal nav-link" href="#id295">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id291">
+ <a class="reference internal nav-link" href="#id296">
Example
</a>
</li>
@@ -4300,12 +4325,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id292">
+ <a class="reference internal nav-link" href="#id297">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id293">
+ <a class="reference internal nav-link" href="#id298">
Example
</a>
</li>
@@ -4321,7 +4346,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id294">
+ <a class="reference internal nav-link" href="#id299">
Example
</a>
</li>
@@ -5211,6 +5236,15 @@ This can be used to perform the inverse operation of <a class="reference interna
</pre></div>
</div>
</section>
+<section id="alternative-syntax">
+<h4>Alternative Syntax<a class="headerlink" href="#alternative-syntax" title="Link to this heading">¶</a></h4>
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">trim</span><span class="p">(</span><span class="k">BOTH</span><span class="w"> </span><span class="n">trim_str</span><span class="w"> </span><span class="k">FROM</span><span class="w"> </span><span class="n">str</span><span class="p">)</span>
+</pre></div>
+</div>
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">trim</span><span class="p">(</span><span class="n">trim_str</span><span class="w"> </span><span class="k">FROM</span><span class="w"> </span><span class="n">str</span><span class="p">)</span>
+</pre></div>
+</div>
+</section>
<section id="id50">
<h4>Aliases<a class="headerlink" href="#id50" title="Link to this heading">¶</a></h4>
<ul class="simple">
@@ -5610,6 +5644,12 @@ This can be used to perform the inverse operation of <a class="reference interna
<span class="o">+</span><span class="c1">-------------------------------------------+</span>
</pre></div>
</div>
+</section>
+<section id="id78">
+<h4>Alternative Syntax<a class="headerlink" href="#id78" title="Link to this heading">¶</a></h4>
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">trim</span><span class="p">(</span><span class="k">LEADING</span><span class="w"> </span><span class="n">trim_str</span><span class="w"> </span><span class="k">FROM</span><span class="w"> </span><span class="n">str</span><span class="p">)</span>
+</pre></div>
+</div>
<p><strong>Related functions</strong>:</p>
<ul class="simple">
<li><p><a class="reference internal" href="#btrim">btrim</a></p></li>
@@ -5623,14 +5663,14 @@ 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">octet_length</span><span class="p">(</span><span class="nb">str</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id78">
-<h4>Arguments<a class="headerlink" href="#id78" title="Link to this heading">¶</a></h4>
+<section id="id79">
+<h4>Arguments<a class="headerlink" href="#id79" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id79">
-<h4>Example<a class="headerlink" href="#id79" title="Link to this heading">¶</a></h4>
+<section id="id80">
+<h4>Example<a class="headerlink" href="#id80" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="k">octet_length</span><span class="p">(</span><span class="s1">'Ångström'</span><span class="p">);</span>
<span class="o">+</span><span class="c1">--------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="k">octet_length</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"Ångström"</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -5656,15 +5696,15 @@ 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">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="id80">
-<h4>Arguments<a class="headerlink" href="#id80" title="Link to this heading">¶</a></h4>
+<section id="id81">
+<h4>Arguments<a class="headerlink" href="#id81" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>n</strong>: Number of times to repeat the input string.</p></li>
</ul>
</section>
-<section id="id81">
-<h4>Example<a class="headerlink" href="#id81" title="Link to this heading">¶</a></h4>
+<section id="id82">
+<h4>Example<a class="headerlink" href="#id82" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">repeat</span><span class="p">(</span><span class="s1">'data'</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">);</span>
<span class="o">+</span><span class="c1">-------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">repeat</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"data"</span><span class="p">),</span><span class="n">Int64</span><span class="p">(</span><span class="mi">3</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -5681,16 +5721,16 @@ 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">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="id82">
-<h4>Arguments<a class="headerlink" href="#id82" title="Link to this heading">¶</a></h4>
+<section id="id83">
+<h4>Arguments<a class="headerlink" href="#id83" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>substr</strong>: Substring expression to replace in the input string. Substring expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>replacement</strong>: Replacement substring expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id83">
-<h4>Example<a class="headerlink" href="#id83" title="Link to this heading">¶</a></h4>
+<section id="id84">
+<h4>Example<a class="headerlink" href="#id84" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="k">replace</span><span class="p">(</span><span class="s1">'ABabbaBA'</span><span class="p">,</span><span class="w"> </span><span class="s1">'ab'</span><span class="p">,</span><span class="w"> </span><span class="s1">'cd'</span><span class="p">);</span>
<span class="o">+</span><span class="c1">-------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="k">replace</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"ABabbaBA"</span><span class="p">),</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"ab"</span><span class="p">),</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"cd"</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -5707,14 +5747,14 @@ 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">reverse</span><span class="p">(</span><span class="nb">str</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id84">
-<h4>Arguments<a class="headerlink" href="#id84" title="Link to this heading">¶</a></h4>
+<section id="id85">
+<h4>Arguments<a class="headerlink" href="#id85" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id85">
-<h4>Example<a class="headerlink" href="#id85" title="Link to this heading">¶</a></h4>
+<section id="id86">
+<h4>Example<a class="headerlink" href="#id86" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">reverse</span><span class="p">(</span><span class="s1">'datafusion'</span><span class="p">);</span>
<span class="o">+</span><span class="c1">-----------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">reverse</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"datafusion"</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -5731,15 +5771,15 @@ 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">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="id86">
-<h4>Arguments<a class="headerlink" href="#id86" title="Link to this heading">¶</a></h4>
+<section id="id87">
+<h4>Arguments<a class="headerlink" href="#id87" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>n</strong>: Number of characters to return</p></li>
</ul>
</section>
-<section id="id87">
-<h4>Example<a class="headerlink" href="#id87" title="Link to this heading">¶</a></h4>
+<section id="id88">
+<h4>Example<a class="headerlink" href="#id88" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="k">right</span><span class="p">(</span><span class="s1">'datafusion'</span><span class="p">,</span><span class="w"> </span><span class="mi">6</span><span class="p">);</span>
<span class="o">+</span><span class="c1">------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="k">right</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"datafusion"</span><span class="p">),</span><span class="n">Int64</span><span class="p">(</span><span class="mi">6</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -5760,16 +5800,16 @@ 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">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="id88">
-<h4>Arguments<a class="headerlink" href="#id88" title="Link to this heading">¶</a></h4>
+<section id="id89">
+<h4>Arguments<a class="headerlink" href="#id89" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>n</strong>: String length to pad to.</p></li>
<li><p><strong>padding_str</strong>: String expression to pad with. Can be a constant, column, or function, and any combination of string operators. <em>Default is a space.</em></p></li>
</ul>
</section>
-<section id="id89">
-<h4>Example<a class="headerlink" href="#id89" title="Link to this heading">¶</a></h4>
+<section id="id90">
+<h4>Example<a class="headerlink" href="#id90" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">rpad</span><span class="p">(</span><span class="s1">'datafusion'</span><span class="p">,</span><span class="w"> </span><span class="mi">20</span><span class="p">,</span><span class="w"> </span><span class="s1">'_-'</span><span class="p">);</span>
<span class="o">+</span><span class="c1">-----------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">rpad</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"datafusion"</span><span class="p">),</span><span class="n">Int64</span><span class="p">(</span><span class="mi">20</span><span class="p">),</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"_-"</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -5790,15 +5830,15 @@ 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">rtrim</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="id90">
-<h4>Arguments<a class="headerlink" href="#id90" title="Link to this heading">¶</a></h4>
+<section id="id91">
+<h4>Arguments<a class="headerlink" href="#id91" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>trim_str</strong>: String expression to trim from the end of the input string. Can be a constant, column, or function, and any combination of arithmetic operators. <em>Default is whitespace characters.</em></p></li>
</ul>
</section>
-<section id="id91">
-<h4>Example<a class="headerlink" href="#id91" title="Link to this heading">¶</a></h4>
+<section id="id92">
+<h4>Example<a class="headerlink" href="#id92" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">rtrim</span><span class="p">(</span><span class="s1">' datafusion '</span><span class="p">);</span>
<span class="o">+</span><span class="c1">-------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">rtrim</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">" datafusion "</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -5813,6 +5853,12 @@ This can be used to perform the inverse operation of <a class="reference interna
<span class="o">+</span><span class="c1">-------------------------------------------+</span>
</pre></div>
</div>
+</section>
+<section id="id93">
+<h4>Alternative Syntax<a class="headerlink" href="#id93" title="Link to this heading">¶</a></h4>
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">trim</span><span class="p">(</span><span class="k">TRAILING</span><span class="w"> </span><span class="n">trim_str</span><span class="w"> </span><span class="k">FROM</span><span class="w"> </span><span class="n">str</span><span class="p">)</span>
+</pre></div>
+</div>
<p><strong>Related functions</strong>:</p>
<ul class="simple">
<li><p><a class="reference internal" href="#btrim">btrim</a></p></li>
@@ -5826,16 +5872,16 @@ 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">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="id92">
-<h4>Arguments<a class="headerlink" href="#id92" title="Link to this heading">¶</a></h4>
+<section id="id94">
+<h4>Arguments<a class="headerlink" href="#id94" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>delimiter</strong>: String or character to split on.</p></li>
<li><p><strong>pos</strong>: Position of the part to return.</p></li>
</ul>
</section>
-<section id="id93">
-<h4>Example<a class="headerlink" href="#id93" title="Link to this heading">¶</a></h4>
+<section id="id95">
+<h4>Example<a class="headerlink" href="#id95" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">split_part</span><span class="p">(</span><span class="s1">'1.2.3.4.5'</span><span class="p">,</span><span class="w"> </span><span class="s1">'.'</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">);</span>
<span class="o">+</span><span class="c1">--------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">split_part</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"1.2.3.4.5"</span><span class="p">),</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"."</span><span class="p">),</span><span class="n">Int64</span><span class="p">(</span><span class="mi">3</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -5852,16 +5898,16 @@ 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">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="id94">
-<h4>Arguments<a class="headerlink" href="#id94" title="Link to this heading">¶</a></h4>
+<section id="id96">
+<h4>Arguments<a class="headerlink" href="#id96" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>substr</strong>: Substring to test for.</p></li>
</ul>
</section>
-<section id="id95">
-<h4>Example<a class="headerlink" href="#id95" title="Link to this heading">¶</a></h4>
-<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">starts_with</span><span class="p">(</span><span class="s1">'datafusion'</span><span class="p">,</span><span class="s1">'data'</span><span class="p">);</span>
+<section id="id97">
+<h4>Example<a class="headerlink" href="#id97" title="Link to this heading">¶</a></h4>
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">starts_with</span><span class="p">(</span><span class="s1">'datafusion'</span><span class="p">,</span><span class="s1">'data'</span><span class="p">);</span>
<span class="o">+</span><span class="c1">----------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">starts_with</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"datafusion"</span><span class="p">),</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"data"</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
<span class="o">+</span><span class="c1">----------------------------------------------+</span>
@@ -5877,15 +5923,15 @@ 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">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="id96">
-<h4>Arguments<a class="headerlink" href="#id96" title="Link to this heading">¶</a></h4>
+<section id="id98">
+<h4>Arguments<a class="headerlink" href="#id98" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>substr</strong>: Substring expression to search for.</p></li>
</ul>
</section>
-<section id="id97">
-<h4>Example<a class="headerlink" href="#id97" title="Link to this heading">¶</a></h4>
+<section id="id99">
+<h4>Example<a class="headerlink" href="#id99" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">strpos</span><span class="p">(</span><span class="s1">'datafusion'</span><span class="p">,</span><span class="w"> </span><span class="s1">'fus'</span><span class="p">);</span>
<span class="o">+</span><span class="c1">----------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">strpos</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"datafusion"</span><span class="p">),</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"fus"</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -5895,14 +5941,14 @@ This can be used to perform the inverse operation of <a class="reference interna
</pre></div>
</div>
</section>
-<section id="alternative-syntax">
-<h4>Alternative Syntax<a class="headerlink" href="#alternative-syntax" title="Link to this heading">¶</a></h4>
+<section id="id100">
+<h4>Alternative Syntax<a class="headerlink" href="#id100" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">position</span><span class="p">(</span><span class="n">substr</span><span class="w"> </span><span class="k">in</span><span class="w"> </span><span class="n">origstr</span><span class="p">)</span>
</pre></div>
</div>
</section>
-<section id="id98">
-<h4>Aliases<a class="headerlink" href="#id98" title="Link to this heading">¶</a></h4>
+<section id="id101">
+<h4>Aliases<a class="headerlink" href="#id101" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>instr</p></li>
<li><p>position</p></li>
@@ -5915,16 +5961,16 @@ 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">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="id99">
-<h4>Arguments<a class="headerlink" href="#id99" title="Link to this heading">¶</a></h4>
+<section id="id102">
+<h4>Arguments<a class="headerlink" href="#id102" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>start_pos</strong>: Character position to start the substring at. The first character in the string has a position of 1.</p></li>
<li><p><strong>length</strong>: Number of characters to extract. If not specified, returns the rest of the string after the start position.</p></li>
</ul>
</section>
-<section id="id100">
-<h4>Example<a class="headerlink" href="#id100" title="Link to this heading">¶</a></h4>
+<section id="id103">
+<h4>Example<a class="headerlink" href="#id103" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">substr</span><span class="p">(</span><span class="s1">'datafusion'</span><span class="p">,</span><span class="w"> </span><span class="mi">5</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">);</span>
<span class="o">+</span><span class="c1">----------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">substr</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"datafusion"</span><span class="p">),</span><span class="n">Int64</span><span class="p">(</span><span class="mi">5</span><span class="p">),</span><span class="n">Int64</span><span class="p">(</span><span class="mi">3</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -5934,8 +5980,14 @@ This can be used to perform the inverse operation of <a class="reference interna
</pre></div>
</div>
</section>
-<section id="id101">
-<h4>Aliases<a class="headerlink" href="#id101" title="Link to this heading">¶</a></h4>
+<section id="id104">
+<h4>Alternative Syntax<a class="headerlink" href="#id104" title="Link to this heading">¶</a></h4>
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">substring</span><span class="p">(</span><span class="n">str</span><span class="w"> </span><span class="k">from</span><span class="w"> </span><span class="n">start_pos</span><span class="w"> </span><span class="k">for</span><span class="w"> </span><span class="k">length</span><span class="p">)</span>
+</pre></div>
+</div>
+</section>
+<section id="id105">
+<h4>Aliases<a class="headerlink" href="#id105" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>substring</p></li>
</ul>
@@ -5949,16 +6001,16 @@ If count is negative, everything to the right of the final delimiter (counting f
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">substr_index</span><span class="p">(</span><span class="nb">str</span><span class="p">,</span> <span class="n">delim</span><span class="p">,</span> <span class="n">count</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id102">
-<h4>Arguments<a class="headerlink" href="#id102" title="Link to this heading">¶</a></h4>
+<section id="id106">
+<h4>Arguments<a class="headerlink" href="#id106" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>delim</strong>: The string to find in str to split str.</p></li>
<li><p><strong>count</strong>: The number of times to search for the delimiter. Can be either a positive or negative number.</p></li>
</ul>
</section>
-<section id="id103">
-<h4>Example<a class="headerlink" href="#id103" title="Link to this heading">¶</a></h4>
+<section id="id107">
+<h4>Example<a class="headerlink" href="#id107" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">substr_index</span><span class="p">(</span><span class="s1">'www.apache.org'</span><span class="p">,</span><span class="w"> </span><span class="s1">'.'</span><span class="p">,</span><span class="w"> </span><span class="mi">1</span><span class="p">);</span>
<span class="o">+</span><span class="c1">---------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">substr_index</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"www.apache.org"</span><span class="p">),</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"."</span><span class="p">),</span><span class="n">Int64</span><span class="p">(</span><span class="mi">1</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -5974,8 +6026,8 @@ If count is negative, everything to the right of the final delimiter (counting f
</pre></div>
</div>
</section>
-<section id="id104">
-<h4>Aliases<a class="headerlink" href="#id104" title="Link to this heading">¶</a></h4>
+<section id="id108">
+<h4>Aliases<a class="headerlink" href="#id108" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>substring_index</p></li>
</ul>
@@ -5995,14 +6047,14 @@ If count is negative, everything to the right of the final delimiter (counting f
<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="id105">
-<h4>Arguments<a class="headerlink" href="#id105" title="Link to this heading">¶</a></h4>
+<section id="id109">
+<h4>Arguments<a class="headerlink" href="#id109" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>int</strong>: Integer expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id106">
-<h4>Example<a class="headerlink" href="#id106" title="Link to this heading">¶</a></h4>
+<section id="id110">
+<h4>Example<a class="headerlink" href="#id110" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">to_hex</span><span class="p">(</span><span class="mi">12345689</span><span class="p">);</span>
<span class="o">+</span><span class="c1">-------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">to_hex</span><span class="p">(</span><span class="n">Int64</span><span class="p">(</span><span class="mi">12345689</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -6019,16 +6071,16 @@ If count is negative, everything to the right of the final delimiter (counting f
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">translate</span><span class="p">(</span><span class="nb">str</span><span class="p">,</span> <span class="n">chars</span><span class="p">,</span> <span class="n">translation</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id107">
-<h4>Arguments<a class="headerlink" href="#id107" title="Link to this heading">¶</a></h4>
+<section id="id111">
+<h4>Arguments<a class="headerlink" href="#id111" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>chars</strong>: Characters to translate.</p></li>
<li><p><strong>translation</strong>: Translation characters. Translation characters replace only characters at the same position in the <strong>chars</strong> string.</p></li>
</ul>
</section>
-<section id="id108">
-<h4>Example<a class="headerlink" href="#id108" title="Link to this heading">¶</a></h4>
+<section id="id112">
+<h4>Example<a class="headerlink" href="#id112" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="k">translate</span><span class="p">(</span><span class="s1">'twice'</span><span class="p">,</span><span class="w"> </span><span class="s1">'wic'</span><span class="p">,</span><span class="w"> </span><span class="s1">'her'</span><span class="p">);</span>
<span class="o">+</span><span class="c1">--------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="k">translate</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"twice"</span><span class="p">),</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"wic"</span><span class="p">),</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"her"</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -6049,14 +6101,14 @@ If count is negative, everything to the right of the final delimiter (counting f
<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="id109">
-<h4>Arguments<a class="headerlink" href="#id109" title="Link to this heading">¶</a></h4>
+<section id="id113">
+<h4>Arguments<a class="headerlink" href="#id113" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id110">
-<h4>Example<a class="headerlink" href="#id110" title="Link to this heading">¶</a></h4>
+<section id="id114">
+<h4>Example<a class="headerlink" href="#id114" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="k">upper</span><span class="p">(</span><span class="s1">'dataFusion'</span><span class="p">);</span>
<span class="o">+</span><span class="c1">---------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="k">upper</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"dataFusion"</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -6078,8 +6130,8 @@ If count is negative, everything to the right of the final delimiter (counting f
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">uuid</span><span class="p">()</span>
</pre></div>
</div>
-<section id="id111">
-<h4>Example<a class="headerlink" href="#id111" title="Link to this heading">¶</a></h4>
+<section id="id115">
+<h4>Example<a class="headerlink" href="#id115" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">uuid</span><span class="p">();</span>
<span class="o">+</span><span class="c1">--------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">uuid</span><span class="p">()</span><span class="w"> </span><span class="o">|</span>
@@ -6103,8 +6155,8 @@ If count is negative, everything to the right of the final delimiter (counting f
<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="id112">
-<h4>Arguments<a class="headerlink" href="#id112" title="Link to this heading">¶</a></h4>
+<section id="id116">
+<h4>Arguments<a class="headerlink" href="#id116" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>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>
@@ -6121,8 +6173,8 @@ If count is negative, everything to the right of the final delimiter (counting f
<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="id113">
-<h4>Arguments<a class="headerlink" href="#id113" title="Link to this heading">¶</a></h4>
+<section id="id117">
+<h4>Arguments<a class="headerlink" href="#id117" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression containing string or binary data</p></li>
<li><p><strong>format</strong>: Supported formats are: <code class="docutils literal notranslate"><span class="pre">base64</span></code>, <code class="docutils literal notranslate"><span class="pre">hex</span></code></p></li>
@@ -6152,8 +6204,8 @@ The following regular expression functions are supported:</p>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">regexp_count</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">start</span><span class="p">,</span> <span class="n">flags</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id114">
-<h4>Arguments<a class="headerlink" href="#id114" title="Link to this heading">¶</a></h4>
+<section id="id118">
+<h4>Arguments<a class="headerlink" href="#id118" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>regexp</strong>: Regular expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
@@ -6169,8 +6221,8 @@ The following regular expression functions are supported:</p>
</li>
</ul>
</section>
-<section id="id115">
-<h4>Example<a class="headerlink" href="#id115" title="Link to this heading">¶</a></h4>
+<section id="id119">
+<h4>Example<a class="headerlink" href="#id119" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">regexp_count</span><span class="p">(</span><span class="s1">'abcAbAbc'</span><span class="p">,</span><span class="w"> </span><span class="s1">'abc'</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span>< [...]
<span class="o">+</span><span class="c1">---------------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">regexp_count</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"abcAbAbc"</span><span class="p">),</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"abc"</span><span class="p">),</span><span class="n">Int64</span><span class="p">(</span><span class="mi">2</span><span class="p">),</span><span class="n">Utf8</span><span class="p">(</sp [...]
@@ -6187,8 +6239,8 @@ The following regular expression functions are supported:</p>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">regexp_like</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">flags</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id116">
-<h4>Arguments<a class="headerlink" href="#id116" title="Link to this heading">¶</a></h4>
+<section id="id120">
+<h4>Arguments<a class="headerlink" href="#id120" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>regexp</strong>: Regular expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
@@ -6203,8 +6255,8 @@ The following regular expression functions are supported:</p>
</li>
</ul>
</section>
-<section id="id117">
-<h4>Example<a class="headerlink" href="#id117" title="Link to this heading">¶</a></h4>
+<section id="id121">
+<h4>Example<a class="headerlink" href="#id121" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">select</span><span class="w"> </span><span class="n">regexp_like</span><span class="p">(</span><span class="s1">'Köln'</span><span class="p">,</span><span class="w"> </span><span class="s1">'[a-zA-Z]ö[a-zA-Z]{2}'</span><span class="p">);</span>
<span class="o">+</span><span class="c1">--------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">regexp_like</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"Köln"</span><span class="p">),</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"[a-zA-Z]ö[a-zA-Z]{2}"</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -6228,8 +6280,8 @@ The following regular expression functions are supported:</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> <span class="n">flags</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id118">
-<h4>Arguments<a class="headerlink" href="#id118" title="Link to this heading">¶</a></h4>
+<section id="id122">
+<h4>Arguments<a class="headerlink" href="#id122" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>regexp</strong>: Regular expression to match against.
@@ -6245,8 +6297,8 @@ Can be a constant, column, or function.</p></li>
</li>
</ul>
</section>
-<section id="id119">
-<h4>Example<a class="headerlink" href="#id119" title="Link to this heading">¶</a></h4>
+<section id="id123">
+<h4>Example<a class="headerlink" href="#id123" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="w"> </span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">regexp_match</span><span class="p">(</span><span class="s1">'Köln'</span><span class="p">,</span><span class="w"> </span><span class="s1">'[a-zA-Z]ö[a-zA-Z]{2}'</span><span class="p">);</span>
<span class="w"> </span><span class="o">+</span><span class="c1">---------------------------------------------------------+</span>
<span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">regexp_match</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"Köln"</span><span class="p">),</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"[a-zA-Z]ö[a-zA-Z]{2}"</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -6270,8 +6322,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="id120">
-<h4>Arguments<a class="headerlink" href="#id120" title="Link to this heading">¶</a></h4>
+<section id="id124">
+<h4>Arguments<a class="headerlink" href="#id124" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>regexp</strong>: Regular expression to match against.
@@ -6286,8 +6338,8 @@ Can be a constant, column, or function.</p></li>
<li><p><strong>U</strong>: swap the meaning of x* and x*?</p></li>
</ul>
</section>
-<section id="id121">
-<h4>Example<a class="headerlink" href="#id121" title="Link to this heading">¶</a></h4>
+<section id="id125">
+<h4>Example<a class="headerlink" href="#id125" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">regexp_replace</span><span class="p">(</span><span class="s1">'foobarbaz'</span><span class="p">,</span><span class="w"> </span><span class="s1">'b(..)'</span><span class="p">,</span><span class="w"> </span><span class="s1">'X\\1Y'</span><span class="p">,</span><span [...]
<span class="o">+</span><span class="c1">------------------------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">regexp_replace</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"foobarbaz"</span><span class="p">),</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"b(..)"</span><span class="p">),</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"X\1Y"</span><span class="p">),</span><span class="n">Utf8</span><s [...]
@@ -6339,8 +6391,8 @@ Can be a constant, column, or function.</p></li>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">current_date</span><span class="p">()</span>
</pre></div>
</div>
-<section id="id122">
-<h4>Aliases<a class="headerlink" href="#id122" title="Link to this heading">¶</a></h4>
+<section id="id126">
+<h4>Aliases<a class="headerlink" href="#id126" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>today</p></li>
</ul>
@@ -6365,8 +6417,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_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="id123">
-<h4>Arguments<a class="headerlink" href="#id123" title="Link to this heading">¶</a></h4>
+<section id="id127">
+<h4>Arguments<a class="headerlink" href="#id127" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>interval</strong>: Bin interval.</p></li>
<li><p><strong>expression</strong>: Time expression to operate on. Can be a constant, column, or function.</p></li>
@@ -6398,8 +6450,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="id124">
-<h4>Arguments<a class="headerlink" href="#id124" title="Link to this heading">¶</a></h4>
+<section id="id128">
+<h4>Arguments<a class="headerlink" href="#id128" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>part</strong>: Part of the date to return. The following date parts are supported:</p>
<ul>
@@ -6422,8 +6474,14 @@ Can be a constant, column, or function.</p></li>
<li><p><strong>expression</strong>: Time expression to operate on. Can be a constant, column, or function.</p></li>
</ul>
</section>
-<section id="id125">
-<h4>Aliases<a class="headerlink" href="#id125" title="Link to this heading">¶</a></h4>
+<section id="id129">
+<h4>Alternative Syntax<a class="headerlink" href="#id129" title="Link to this heading">¶</a></h4>
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">extract</span><span class="p">(</span><span class="n">field</span><span class="w"> </span><span class="k">FROM</span><span class="w"> </span><span class="k">source</span><span class="p">)</span>
+</pre></div>
+</div>
+</section>
+<section id="id130">
+<h4>Aliases<a class="headerlink" href="#id130" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>datepart</p></li>
</ul>
@@ -6435,8 +6493,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="id126">
-<h4>Arguments<a class="headerlink" href="#id126" title="Link to this heading">¶</a></h4>
+<section id="id131">
+<h4>Arguments<a class="headerlink" href="#id131" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>precision</strong>: Time precision to truncate to. The following precisions are supported:</p>
<ul>
@@ -6453,8 +6511,8 @@ Can be a constant, column, or function.</p></li>
<li><p><strong>expression</strong>: Time expression to operate on. Can be a constant, column, or function.</p></li>
</ul>
</section>
-<section id="id127">
-<h4>Aliases<a class="headerlink" href="#id127" title="Link to this heading">¶</a></h4>
+<section id="id132">
+<h4>Aliases<a class="headerlink" href="#id132" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>datetrunc</p></li>
</ul>
@@ -6474,8 +6532,8 @@ Can be a constant, column, or function.</p></li>
<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="id128">
-<h4>Arguments<a class="headerlink" href="#id128" title="Link to this heading">¶</a></h4>
+<section id="id133">
+<h4>Arguments<a class="headerlink" href="#id133" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on. Can be a constant, column, or function, and any combination of arithmetic operators.</p></li>
</ul>
@@ -6487,16 +6545,16 @@ Can be a constant, column, or function.</p></li>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">make_date</span><span class="p">(</span><span class="n">year</span><span class="p">,</span> <span class="n">month</span><span class="p">,</span> <span class="n">day</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id129">
-<h4>Arguments<a class="headerlink" href="#id129" title="Link to this heading">¶</a></h4>
+<section id="id134">
+<h4>Arguments<a class="headerlink" href="#id134" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>year</strong>: Year to use when making the date. Can be a constant, column or function, and any combination of arithmetic operators.</p></li>
<li><p><strong>month</strong>: Month to use when making the date. Can be a constant, column or function, and any combination of arithmetic operators.</p></li>
<li><p><strong>day</strong>: Day to use when making the date. Can be a constant, column or function, and any combination of arithmetic operators.</p></li>
</ul>
</section>
-<section id="id130">
-<h4>Example<a class="headerlink" href="#id130" title="Link to this heading">¶</a></h4>
+<section id="id135">
+<h4>Example<a class="headerlink" href="#id135" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">make_date</span><span class="p">(</span><span class="mi">2023</span><span class="p">,</span><span class="w"> </span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">31</span><span class="p">);</span>
<span class="o">+</span><span class="c1">-------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">make_date</span><span class="p">(</span><span class="n">Int64</span><span class="p">(</span><span class="mi">2023</span><span class="p">),</span><span class="n">Int64</span><span class="p">(</span><span class="mi">1</span><span class="p">),</span><span class="n">Int64</span><span class="p">(</span><span class="mi">31</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -6521,8 +6579,8 @@ Can be a constant, column, or function.</p></li>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">now</span><span class="p">()</span>
</pre></div>
</div>
-<section id="id131">
-<h4>Aliases<a class="headerlink" href="#id131" title="Link to this heading">¶</a></h4>
+<section id="id136">
+<h4>Aliases<a class="headerlink" href="#id136" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>current_timestamp</p></li>
</ul>
@@ -6534,16 +6592,16 @@ Can be a constant, column, or function.</p></li>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">to_char</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="id132">
-<h4>Arguments<a class="headerlink" href="#id132" title="Link to this heading">¶</a></h4>
+<section id="id137">
+<h4>Arguments<a class="headerlink" href="#id137" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on. Can be a constant, column, or function that results in a date, time, timestamp or duration.</p></li>
<li><p><strong>format</strong>: A <a class="reference external" href="https://docs.rs/chrono/latest/chrono/format/strftime/index.html">Chrono format</a> string to use to convert the expression.</p></li>
<li><p><strong>day</strong>: Day to use when making the date. Can be a constant, column or function, and any combination of arithmetic operators.</p></li>
</ul>
</section>
-<section id="id133">
-<h4>Example<a class="headerlink" href="#id133" title="Link to this heading">¶</a></h4>
+<section id="id138">
+<h4>Example<a class="headerlink" href="#id138" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">to_char</span><span class="p">(</span><span class="s1">'2023-03-01'</span><span class="p">::</span><span class="nb">date</span><span class="p">,</span><span class="w"> </span><span class="s1">'%d-%m-%Y'</span><span class="p">);</span>
<span class="o">+</span><span class="c1">----------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">to_char</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"2023-03-01"</span><span class="p">),</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"%d-%m-%Y"</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -6554,8 +6612,8 @@ Can be a constant, column, or function.</p></li>
</div>
<p>Additional examples can be found <a class="reference external" href="https://github.com/apache/datafusion/blob/main/datafusion-examples/examples/to_char.rs">here</a></p>
</section>
-<section id="id134">
-<h4>Aliases<a class="headerlink" href="#id134" title="Link to this heading">¶</a></h4>
+<section id="id139">
+<h4>Aliases<a class="headerlink" href="#id139" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>date_format</p></li>
</ul>
@@ -6572,8 +6630,8 @@ Returns the corresponding date.</p>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">to_date</span><span class="p">(</span><span class="s1">'2017-05-31'</span><span class="p">,</span> <span class="s1">'%Y-%m-</span><span class="si">%d</span><span class="s1">'</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id135">
-<h4>Arguments<a class="headerlink" href="#id135" title="Link to this heading">¶</a></h4>
+<section id="id140">
+<h4>Arguments<a class="headerlink" href="#id140" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>format_n</strong>: Optional <a class="reference external" href="https://docs.rs/chrono/latest/chrono/format/strftime/index.html">Chrono format</a> strings to use to parse the expression. Formats will be tried in the order
@@ -6581,8 +6639,8 @@ they appear with the first successful one being returned. If none of the formats
an error will be returned.</p></li>
</ul>
</section>
-<section id="id136">
-<h4>Example<a class="headerlink" href="#id136" title="Link to this heading">¶</a></h4>
+<section id="id141">
+<h4>Example<a class="headerlink" href="#id141" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">to_date</span><span class="p">(</span><span class="s1">'2023-01-31'</span><span class="p">);</span>
<span class="o">+</span><span class="c1">-----------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">to_date</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"2023-01-31"</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -6606,14 +6664,14 @@ an error will be returned.</p></li>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">to_local_time</span><span class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id137">
-<h4>Arguments<a class="headerlink" href="#id137" title="Link to this heading">¶</a></h4>
+<section id="id142">
+<h4>Arguments<a class="headerlink" href="#id142" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Time expression to operate on. Can be a constant, column, or function.</p></li>
</ul>
</section>
-<section id="id138">
-<h4>Example<a class="headerlink" href="#id138" title="Link to this heading">¶</a></h4>
+<section id="id143">
+<h4>Example<a class="headerlink" href="#id143" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">SELECT</span><span class="w"> </span><span class="n">to_local_time</span><span class="p">(</span><span class="s1">'2024-04-01T00:00:20Z'</span><span class="p">::</span><span class="k">timestamp</span><span class="p">);</span>
<span class="o">+</span><span class="c1">---------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">to_local_time</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"2024-04-01T00:00:20Z"</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -6669,15 +6727,15 @@ an error will be returned.</p></li>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">to_timestamp</span><span class="p">(</span><span class="n">expression</span><span class="p">[,</span> <span class="o">...</span><span class="p">,</span> <span class="n">format_n</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id139">
-<h4>Arguments<a class="headerlink" href="#id139" title="Link to this heading">¶</a></h4>
+<section id="id144">
+<h4>Arguments<a class="headerlink" href="#id144" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on. Can be a constant, column, or function, and any combination of arithmetic operators.</p></li>
<li><p><strong>format_n</strong>: Optional <a class="reference external" href="https://docs.rs/chrono/latest/chrono/format/strftime/index.html">Chrono format</a> strings to use to parse the expression. Formats will be tried in the order they appear with the first successful one being returned. If none of the formats successfully parse the expression an error will be returned.</p></li>
</ul>
</section>
-<section id="id140">
-<h4>Example<a class="headerlink" href="#id140" title="Link to this heading">¶</a></h4>
+<section id="id145">
+<h4>Example<a class="headerlink" href="#id145" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">to_timestamp</span><span class="p">(</span><span class="s1">'2023-01-31T09:26:56.123456789-05:00'</span><span class="p">);</span>
<span class="o">+</span><span class="c1">-----------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">to_timestamp</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"2023-01-31T09:26:56.123456789-05:00"</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -6701,15 +6759,15 @@ an error will be returned.</p></li>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">to_timestamp_micros</span><span class="p">(</span><span class="n">expression</span><span class="p">[,</span> <span class="o">...</span><span class="p">,</span> <span class="n">format_n</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id141">
-<h4>Arguments<a class="headerlink" href="#id141" title="Link to this heading">¶</a></h4>
+<section id="id146">
+<h4>Arguments<a class="headerlink" href="#id146" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on. Can be a constant, column, or function, and any combination of arithmetic operators.</p></li>
<li><p><strong>format_n</strong>: Optional <a class="reference external" href="https://docs.rs/chrono/latest/chrono/format/strftime/index.html">Chrono format</a> strings to use to parse the expression. Formats will be tried in the order they appear with the first successful one being returned. If none of the formats successfully parse the expression an error will be returned.</p></li>
</ul>
</section>
-<section id="id142">
-<h4>Example<a class="headerlink" href="#id142" title="Link to this heading">¶</a></h4>
+<section id="id147">
+<h4>Example<a class="headerlink" href="#id147" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">to_timestamp_micros</span><span class="p">(</span><span class="s1">'2023-01-31T09:26:56.123456789-05:00'</span><span class="p">);</span>
<span class="o">+</span><span class="c1">------------------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">to_timestamp_micros</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"2023-01-31T09:26:56.123456789-05:00"</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -6733,15 +6791,15 @@ an error will be returned.</p></li>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">to_timestamp_millis</span><span class="p">(</span><span class="n">expression</span><span class="p">[,</span> <span class="o">...</span><span class="p">,</span> <span class="n">format_n</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id143">
-<h4>Arguments<a class="headerlink" href="#id143" title="Link to this heading">¶</a></h4>
+<section id="id148">
+<h4>Arguments<a class="headerlink" href="#id148" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on. Can be a constant, column, or function, and any combination of arithmetic operators.</p></li>
<li><p><strong>format_n</strong>: Optional <a class="reference external" href="https://docs.rs/chrono/latest/chrono/format/strftime/index.html">Chrono format</a> strings to use to parse the expression. Formats will be tried in the order they appear with the first successful one being returned. If none of the formats successfully parse the expression an error will be returned.</p></li>
</ul>
</section>
-<section id="id144">
-<h4>Example<a class="headerlink" href="#id144" title="Link to this heading">¶</a></h4>
+<section id="id149">
+<h4>Example<a class="headerlink" href="#id149" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">to_timestamp_millis</span><span class="p">(</span><span class="s1">'2023-01-31T09:26:56.123456789-05:00'</span><span class="p">);</span>
<span class="o">+</span><span class="c1">------------------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">to_timestamp_millis</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"2023-01-31T09:26:56.123456789-05:00"</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -6765,15 +6823,15 @@ an error will be returned.</p></li>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">to_timestamp_nanos</span><span class="p">(</span><span class="n">expression</span><span class="p">[,</span> <span class="o">...</span><span class="p">,</span> <span class="n">format_n</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id145">
-<h4>Arguments<a class="headerlink" href="#id145" title="Link to this heading">¶</a></h4>
+<section id="id150">
+<h4>Arguments<a class="headerlink" href="#id150" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on. Can be a constant, column, or function, and any combination of arithmetic operators.</p></li>
<li><p><strong>format_n</strong>: Optional <a class="reference external" href="https://docs.rs/chrono/latest/chrono/format/strftime/index.html">Chrono format</a> strings to use to parse the expression. Formats will be tried in the order they appear with the first successful one being returned. If none of the formats successfully parse the expression an error will be returned.</p></li>
</ul>
</section>
-<section id="id146">
-<h4>Example<a class="headerlink" href="#id146" title="Link to this heading">¶</a></h4>
+<section id="id151">
+<h4>Example<a class="headerlink" href="#id151" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">to_timestamp_nanos</span><span class="p">(</span><span class="s1">'2023-01-31T09:26:56.123456789-05:00'</span><span class="p">);</span>
<span class="o">+</span><span class="c1">-----------------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">to_timestamp_nanos</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"2023-01-31T09:26:56.123456789-05:00"</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -6797,15 +6855,15 @@ an error will be returned.</p></li>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">to_timestamp_seconds</span><span class="p">(</span><span class="n">expression</span><span class="p">[,</span> <span class="o">...</span><span class="p">,</span> <span class="n">format_n</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id147">
-<h4>Arguments<a class="headerlink" href="#id147" title="Link to this heading">¶</a></h4>
+<section id="id152">
+<h4>Arguments<a class="headerlink" href="#id152" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on. Can be a constant, column, or function, and any combination of arithmetic operators.</p></li>
<li><p><strong>format_n</strong>: Optional <a class="reference external" href="https://docs.rs/chrono/latest/chrono/format/strftime/index.html">Chrono format</a> strings to use to parse the expression. Formats will be tried in the order they appear with the first successful one being returned. If none of the formats successfully parse the expression an error will be returned.</p></li>
</ul>
</section>
-<section id="id148">
-<h4>Example<a class="headerlink" href="#id148" title="Link to this heading">¶</a></h4>
+<section id="id153">
+<h4>Example<a class="headerlink" href="#id153" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">to_timestamp_seconds</span><span class="p">(</span><span class="s1">'2023-01-31T09:26:56.123456789-05:00'</span><span class="p">);</span>
<span class="o">+</span><span class="c1">-------------------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">to_timestamp_seconds</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"2023-01-31T09:26:56.123456789-05:00"</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -6829,15 +6887,15 @@ an error will be returned.</p></li>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">to_unixtime</span><span class="p">(</span><span class="n">expression</span><span class="p">[,</span> <span class="o">...</span><span class="p">,</span> <span class="n">format_n</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id149">
-<h4>Arguments<a class="headerlink" href="#id149" title="Link to this heading">¶</a></h4>
+<section id="id154">
+<h4>Arguments<a class="headerlink" href="#id154" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on. Can be a constant, column, or function, and any combination of arithmetic operators.</p></li>
<li><p><strong>format_n</strong>: Optional <a class="reference external" href="https://docs.rs/chrono/latest/chrono/format/strftime/index.html">Chrono format</a> strings to use to parse the expression. Formats will be tried in the order they appear with the first successful one being returned. If none of the formats successfully parse the expression an error will be returned.</p></li>
</ul>
</section>
-<section id="id150">
-<h4>Example<a class="headerlink" href="#id150" title="Link to this heading">¶</a></h4>
+<section id="id155">
+<h4>Example<a class="headerlink" href="#id155" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">to_unixtime</span><span class="p">(</span><span class="s1">'2020-09-08T12:00:00+00:00'</span><span class="p">);</span>
<span class="o">+</span><span class="c1">------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">to_unixtime</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"2020-09-08T12:00:00+00:00"</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -6958,15 +7016,15 @@ an error will be returned.</p></li>
<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="id151">
-<h4>Arguments<a class="headerlink" href="#id151" title="Link to this heading">¶</a></h4>
+<section id="id156">
+<h4>Arguments<a class="headerlink" href="#id156" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>index</strong>: Index to extract the element from the array.</p></li>
</ul>
</section>
-<section id="id152">
-<h4>Example<a class="headerlink" href="#id152" title="Link to this heading">¶</a></h4>
+<section id="id157">
+<h4>Example<a class="headerlink" href="#id157" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_element</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">,</span><span class="w"> </span><span class="mi">4</span><sp [...]
<span class="o">+</span><span class="c1">-----------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_element</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">3</span><span class="p">,</span><span class="mi">4</span><span class="p">]),</span><span class="n">Int64</span><span class="p">(</span><span class="mi">3</span><span class="p">))</span><span class="w"> </span><span cl [...]
@@ -6976,8 +7034,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id153">
-<h4>Aliases<a class="headerlink" href="#id153" title="Link to this heading">¶</a></h4>
+<section id="id158">
+<h4>Aliases<a class="headerlink" href="#id158" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_any_value</p></li>
</ul>
@@ -6989,15 +7047,15 @@ an error will be returned.</p></li>
<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="id154">
-<h4>Arguments<a class="headerlink" href="#id154" title="Link to this heading">¶</a></h4>
+<section id="id159">
+<h4>Arguments<a class="headerlink" href="#id159" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>element</strong>: Element to append to the array.</p></li>
</ul>
</section>
-<section id="id155">
-<h4>Example<a class="headerlink" href="#id155" title="Link to this heading">¶</a></h4>
+<section id="id160">
+<h4>Example<a class="headerlink" href="#id160" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_append</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">],</span><span class="w"> </span><span class="mi">4</span><sp [...]
<span class="o">+</span><span class="c1">--------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_append</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">3</span><span class="p">]),</span><span class="n">Int64</span><span class="p">(</span><span class="mi">4</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -7007,8 +7065,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id156">
-<h4>Aliases<a class="headerlink" href="#id156" title="Link to this heading">¶</a></h4>
+<section id="id161">
+<h4>Aliases<a class="headerlink" href="#id161" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_append</p></li>
<li><p>array_push_back</p></li>
@@ -7026,15 +7084,15 @@ an error will be returned.</p></li>
<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="id157">
-<h4>Arguments<a class="headerlink" href="#id157" title="Link to this heading">¶</a></h4>
+<section id="id162">
+<h4>Arguments<a class="headerlink" href="#id162" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>element</strong>: Element to append to the array.</p></li>
</ul>
</section>
-<section id="id158">
-<h4>Example<a class="headerlink" href="#id158" title="Link to this heading">¶</a></h4>
+<section id="id163">
+<h4>Example<a class="headerlink" href="#id163" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_append</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">],</span><span class="w"> </span><span class="mi">4</span><sp [...]
<span class="o">+</span><span class="c1">--------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_append</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">3</span><span class="p">]),</span><span class="n">Int64</span><span class="p">(</span><span class="mi">4</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -7044,8 +7102,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id159">
-<h4>Aliases<a class="headerlink" href="#id159" title="Link to this heading">¶</a></h4>
+<section id="id164">
+<h4>Aliases<a class="headerlink" href="#id164" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>array_cat</p></li>
<li><p>list_concat</p></li>
@@ -7063,14 +7121,14 @@ an error will be returned.</p></li>
<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="id160">
-<h4>Arguments<a class="headerlink" href="#id160" title="Link to this heading">¶</a></h4>
+<section id="id165">
+<h4>Arguments<a class="headerlink" href="#id165" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
</ul>
</section>
-<section id="id161">
-<h4>Example<a class="headerlink" href="#id161" title="Link to this heading">¶</a></h4>
+<section id="id166">
+<h4>Example<a class="headerlink" href="#id166" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_dims</span><span class="p">([[</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">],</span><span class="w"> </span><span class="p">[</span><span [...]
<span class="o">+</span><span class="c1">---------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_dims</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">3</span><span class="p">,</span><span class="mi">4</span><span class="p">,</span><span class="mi">5</span><span class="p">,</span><span class="mi">6</span><span class="p">]))</span><span class="w"> </span><span class="o" [...]
@@ -7080,8 +7138,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id162">
-<h4>Aliases<a class="headerlink" href="#id162" title="Link to this heading">¶</a></h4>
+<section id="id167">
+<h4>Aliases<a class="headerlink" href="#id167" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_dims</p></li>
</ul>
@@ -7093,15 +7151,15 @@ an error will be returned.</p></li>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">array_distance</span><span class="p">(</span><span class="n">array1</span><span class="p">,</span> <span class="n">array2</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id163">
-<h4>Arguments<a class="headerlink" href="#id163" title="Link to this heading">¶</a></h4>
+<section id="id168">
+<h4>Arguments<a class="headerlink" href="#id168" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array1</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>array2</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
</ul>
</section>
-<section id="id164">
-<h4>Example<a class="headerlink" href="#id164" title="Link to this heading">¶</a></h4>
+<section id="id169">
+<h4>Example<a class="headerlink" href="#id169" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_distance</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">],</span><span class="w"> </span><span class="p">[</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><s [...]
<span class="o">+</span><span class="c1">------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_distance</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">],</span><span class="w"> </span><span class="p">[</span><span class="mi">1</span><span class="p">,</span><span class="mi">4</span><span class="p">]))</span><span class="w"> </span><span class="o">|</span>
@@ -7111,8 +7169,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id165">
-<h4>Aliases<a class="headerlink" href="#id165" title="Link to this heading">¶</a></h4>
+<section id="id170">
+<h4>Aliases<a class="headerlink" href="#id170" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_distance</p></li>
</ul>
@@ -7124,14 +7182,14 @@ an error will be returned.</p></li>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">array_distinct</span><span class="p">(</span><span class="n">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id166">
-<h4>Arguments<a class="headerlink" href="#id166" title="Link to this heading">¶</a></h4>
+<section id="id171">
+<h4>Arguments<a class="headerlink" href="#id171" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
</ul>
</section>
-<section id="id167">
-<h4>Example<a class="headerlink" href="#id167" title="Link to this heading">¶</a></h4>
+<section id="id172">
+<h4>Example<a class="headerlink" href="#id172" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_distinct</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><s [...]
<span class="o">+</span><span class="c1">---------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_distinct</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">3</span><span class="p">,</span><span class="mi">4</span><span class="p">]))</span><span class="w"> </span><span class="o">|</span>
@@ -7141,8 +7199,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id168">
-<h4>Aliases<a class="headerlink" href="#id168" title="Link to this heading">¶</a></h4>
+<section id="id173">
+<h4>Aliases<a class="headerlink" href="#id173" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_distinct</p></li>
</ul>
@@ -7154,15 +7212,15 @@ an error will be returned.</p></li>
<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="id169">
-<h4>Arguments<a class="headerlink" href="#id169" title="Link to this heading">¶</a></h4>
+<section id="id174">
+<h4>Arguments<a class="headerlink" href="#id174" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>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="id170">
-<h4>Example<a class="headerlink" href="#id170" title="Link to this heading">¶</a></h4>
+<section id="id175">
+<h4>Example<a class="headerlink" href="#id175" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_element</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">,</span><span class="w"> </span><span class="mi">4</span><sp [...]
<span class="o">+</span><span class="c1">-----------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_element</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">3</span><span class="p">,</span><span class="mi">4</span><span class="p">]),</span><span class="n">Int64</span><span class="p">(</span><span class="mi">3</span><span class="p">))</span><span class="w"> </span><span cl [...]
@@ -7172,8 +7230,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id171">
-<h4>Aliases<a class="headerlink" href="#id171" title="Link to this heading">¶</a></h4>
+<section id="id176">
+<h4>Aliases<a class="headerlink" href="#id176" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>array_extract</p></li>
<li><p>list_element</p></li>
@@ -7191,15 +7249,15 @@ an error will be returned.</p></li>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">array_except</span><span class="p">(</span><span class="n">array1</span><span class="p">,</span> <span class="n">array2</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id172">
-<h4>Arguments<a class="headerlink" href="#id172" title="Link to this heading">¶</a></h4>
+<section id="id177">
+<h4>Arguments<a class="headerlink" href="#id177" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array1</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>array2</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
</ul>
</section>
-<section id="id173">
-<h4>Example<a class="headerlink" href="#id173" title="Link to this heading">¶</a></h4>
+<section id="id178">
+<h4>Example<a class="headerlink" href="#id178" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_except</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">,</span><span class="w"> </span><span class="mi">4</span><spa [...]
<span class="o">+</span><span class="c1">----------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_except</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">,</span><span class="w"> </span><span class="mi">4</span><span class="p">],</span><span class="w"> </span><span class="p">[</span><span class="mi">5</span><span class="p">,</span><span class="w"> < [...]
@@ -7215,8 +7273,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id174">
-<h4>Aliases<a class="headerlink" href="#id174" title="Link to this heading">¶</a></h4>
+<section id="id179">
+<h4>Aliases<a class="headerlink" href="#id179" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_except</p></li>
</ul>
@@ -7232,15 +7290,15 @@ an error will be returned.</p></li>
<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="id175">
-<h4>Arguments<a class="headerlink" href="#id175" title="Link to this heading">¶</a></h4>
+<section id="id180">
+<h4>Arguments<a class="headerlink" href="#id180" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>element</strong>: Scalar or Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
</ul>
</section>
-<section id="id176">
-<h4>Example<a class="headerlink" href="#id176" title="Link to this heading">¶</a></h4>
+<section id="id181">
+<h4>Example<a class="headerlink" href="#id181" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_has</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">],</span><span class="w"> </span><span class="mi">2</span><span [...]
<span class="o">+</span><span class="c1">-----------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_has</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">3</span><span class="p">]),</span><span class="w"> </span><span class="mi">2</span><span class="p">)</span><span class="w"> </span><span class="o">|</span>
@@ -7250,8 +7308,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id177">
-<h4>Aliases<a class="headerlink" href="#id177" title="Link to this heading">¶</a></h4>
+<section id="id182">
+<h4>Aliases<a class="headerlink" href="#id182" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_has</p></li>
<li><p>array_contains</p></li>
@@ -7265,15 +7323,15 @@ an error will be returned.</p></li>
<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="id178">
-<h4>Arguments<a class="headerlink" href="#id178" title="Link to this heading">¶</a></h4>
+<section id="id183">
+<h4>Arguments<a class="headerlink" href="#id183" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>element</strong>: Scalar or Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
</ul>
</section>
-<section id="id179">
-<h4>Example<a class="headerlink" href="#id179" title="Link to this heading">¶</a></h4>
+<section id="id184">
+<h4>Example<a class="headerlink" href="#id184" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_has</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">],</span><span class="w"> </span><span class="mi">2</span><span [...]
<span class="o">+</span><span class="c1">-----------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_has</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">3</span><span class="p">]),</span><span class="w"> </span><span class="mi">2</span><span class="p">)</span><span class="w"> </span><span class="o">|</span>
@@ -7283,8 +7341,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id180">
-<h4>Aliases<a class="headerlink" href="#id180" title="Link to this heading">¶</a></h4>
+<section id="id185">
+<h4>Aliases<a class="headerlink" href="#id185" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_has_all</p></li>
</ul>
@@ -7296,15 +7354,15 @@ an error will be returned.</p></li>
<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="id181">
-<h4>Arguments<a class="headerlink" href="#id181" title="Link to this heading">¶</a></h4>
+<section id="id186">
+<h4>Arguments<a class="headerlink" href="#id186" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>element</strong>: Scalar or Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
</ul>
</section>
-<section id="id182">
-<h4>Example<a class="headerlink" href="#id182" title="Link to this heading">¶</a></h4>
+<section id="id187">
+<h4>Example<a class="headerlink" href="#id187" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_has</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">],</span><span class="w"> </span><span class="mi">2</span><span [...]
<span class="o">+</span><span class="c1">-----------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_has</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">3</span><span class="p">]),</span><span class="w"> </span><span class="mi">2</span><span class="p">)</span><span class="w"> </span><span class="o">|</span>
@@ -7314,8 +7372,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id183">
-<h4>Aliases<a class="headerlink" href="#id183" title="Link to this heading">¶</a></h4>
+<section id="id188">
+<h4>Aliases<a class="headerlink" href="#id188" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_has_any</p></li>
</ul>
@@ -7331,14 +7389,14 @@ an error will be returned.</p></li>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">array_distinct</span><span class="p">(</span><span class="n">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id184">
-<h4>Arguments<a class="headerlink" href="#id184" title="Link to this heading">¶</a></h4>
+<section id="id189">
+<h4>Arguments<a class="headerlink" href="#id189" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
</ul>
</section>
-<section id="id185">
-<h4>Example<a class="headerlink" href="#id185" title="Link to this heading">¶</a></h4>
+<section id="id190">
+<h4>Example<a class="headerlink" href="#id190" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_distinct</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><s [...]
<span class="o">+</span><span class="c1">---------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_distinct</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">3</span><span class="p">,</span><span class="mi">4</span><span class="p">]))</span><span class="w"> </span><span class="o">|</span>
@@ -7348,8 +7406,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id186">
-<h4>Aliases<a class="headerlink" href="#id186" title="Link to this heading">¶</a></h4>
+<section id="id191">
+<h4>Aliases<a class="headerlink" href="#id191" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_intersect</p></li>
</ul>
@@ -7365,15 +7423,15 @@ an error will be returned.</p></li>
<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="id187">
-<h4>Arguments<a class="headerlink" href="#id187" title="Link to this heading">¶</a></h4>
+<section id="id192">
+<h4>Arguments<a class="headerlink" href="#id192" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>dimension</strong>: Array dimension.</p></li>
</ul>
</section>
-<section id="id188">
-<h4>Example<a class="headerlink" href="#id188" title="Link to this heading">¶</a></h4>
+<section id="id193">
+<h4>Example<a class="headerlink" href="#id193" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_length</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">,</span><span class="w"> </span><span class="mi">4</span><spa [...]
<span class="o">+</span><span class="c1">-------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_length</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">3</span><span class="p">,</span><span class="mi">4</span><span class="p">,</span><span class="mi">5</span><span class="p">]),</span><span class="w"> </span><span class="mi">1</span><span class="p">)</span><span class=" [...]
@@ -7383,8 +7441,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id189">
-<h4>Aliases<a class="headerlink" href="#id189" title="Link to this heading">¶</a></h4>
+<section id="id194">
+<h4>Aliases<a class="headerlink" href="#id194" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_length</p></li>
</ul>
@@ -7396,14 +7454,14 @@ an error will be returned.</p></li>
<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="id190">
-<h4>Arguments<a class="headerlink" href="#id190" title="Link to this heading">¶</a></h4>
+<section id="id195">
+<h4>Arguments<a class="headerlink" href="#id195" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
</ul>
</section>
-<section id="id191">
-<h4>Example<a class="headerlink" href="#id191" title="Link to this heading">¶</a></h4>
+<section id="id196">
+<h4>Example<a class="headerlink" href="#id196" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_dims</span><span class="p">([[</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">],</span><span class="w"> </span><span class="p">[</span><span [...]
<span class="o">+</span><span class="c1">---------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_dims</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">3</span><span class="p">,</span><span class="mi">4</span><span class="p">,</span><span class="mi">5</span><span class="p">,</span><span class="mi">6</span><span class="p">]))</span><span class="w"> </span><span class="o" [...]
@@ -7413,8 +7471,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id192">
-<h4>Aliases<a class="headerlink" href="#id192" title="Link to this heading">¶</a></h4>
+<section id="id197">
+<h4>Aliases<a class="headerlink" href="#id197" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_ndims</p></li>
</ul>
@@ -7426,15 +7484,15 @@ an error will be returned.</p></li>
<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="id193">
-<h4>Arguments<a class="headerlink" href="#id193" title="Link to this heading">¶</a></h4>
+<section id="id198">
+<h4>Arguments<a class="headerlink" href="#id198" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>index</strong>: Index to extract the element from the array.</p></li>
</ul>
</section>
-<section id="id194">
-<h4>Example<a class="headerlink" href="#id194" title="Link to this heading">¶</a></h4>
+<section id="id199">
+<h4>Example<a class="headerlink" href="#id199" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_element</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">,</span><span class="w"> </span><span class="mi">4</span><sp [...]
<span class="o">+</span><span class="c1">-----------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_element</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">3</span><span class="p">,</span><span class="mi">4</span><span class="p">]),</span><span class="n">Int64</span><span class="p">(</span><span class="mi">3</span><span class="p">))</span><span class="w"> </span><span cl [...]
@@ -7444,8 +7502,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id195">
-<h4>Aliases<a class="headerlink" href="#id195" title="Link to this heading">¶</a></h4>
+<section id="id200">
+<h4>Aliases<a class="headerlink" href="#id200" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_pop_back</p></li>
</ul>
@@ -7457,15 +7515,15 @@ an error will be returned.</p></li>
<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="id196">
-<h4>Arguments<a class="headerlink" href="#id196" title="Link to this heading">¶</a></h4>
+<section id="id201">
+<h4>Arguments<a class="headerlink" href="#id201" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>index</strong>: Index to extract the element from the array.</p></li>
</ul>
</section>
-<section id="id197">
-<h4>Example<a class="headerlink" href="#id197" title="Link to this heading">¶</a></h4>
+<section id="id202">
+<h4>Example<a class="headerlink" href="#id202" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_element</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">,</span><span class="w"> </span><span class="mi">4</span><sp [...]
<span class="o">+</span><span class="c1">-----------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_element</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">3</span><span class="p">,</span><span class="mi">4</span><span class="p">]),</span><span class="n">Int64</span><span class="p">(</span><span class="mi">3</span><span class="p">))</span><span class="w"> </span><span cl [...]
@@ -7475,8 +7533,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id198">
-<h4>Aliases<a class="headerlink" href="#id198" title="Link to this heading">¶</a></h4>
+<section id="id203">
+<h4>Aliases<a class="headerlink" href="#id203" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_pop_front</p></li>
</ul>
@@ -7489,16 +7547,16 @@ an error will be returned.</p></li>
<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="id199">
-<h4>Arguments<a class="headerlink" href="#id199" title="Link to this heading">¶</a></h4>
+<section id="id204">
+<h4>Arguments<a class="headerlink" href="#id204" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>element</strong>: Element to search for position in the array.</p></li>
<li><p><strong>index</strong>: Index at which to start searching.</p></li>
</ul>
</section>
-<section id="id200">
-<h4>Example<a class="headerlink" href="#id200" title="Link to this heading">¶</a></h4>
+<section id="id205">
+<h4>Example<a class="headerlink" href="#id205" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_position</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><s [...]
<span class="o">+</span><span class="c1">----------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_position</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">3</span><span class="p">,</span><span class="mi">1</span><span class="p">,</span><span class="mi">4</span><span class="p">]),</span><span class="n">Int64</span><span c [...]
@@ -7514,8 +7572,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id201">
-<h4>Aliases<a class="headerlink" href="#id201" title="Link to this heading">¶</a></h4>
+<section id="id206">
+<h4>Aliases<a class="headerlink" href="#id206" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_position</p></li>
<li><p>array_indexof</p></li>
@@ -7530,16 +7588,16 @@ an error will be returned.</p></li>
<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="id202">
-<h4>Arguments<a class="headerlink" href="#id202" title="Link to this heading">¶</a></h4>
+<section id="id207">
+<h4>Arguments<a class="headerlink" href="#id207" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>element</strong>: Element to search for position in the array.</p></li>
<li><p><strong>index</strong>: Index at which to start searching.</p></li>
</ul>
</section>
-<section id="id203">
-<h4>Example<a class="headerlink" href="#id203" title="Link to this heading">¶</a></h4>
+<section id="id208">
+<h4>Example<a class="headerlink" href="#id208" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_position</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><s [...]
<span class="o">+</span><span class="c1">----------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_position</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">3</span><span class="p">,</span><span class="mi">1</span><span class="p">,</span><span class="mi">4</span><span class="p">]),</span><span class="n">Int64</span><span c [...]
@@ -7555,8 +7613,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id204">
-<h4>Aliases<a class="headerlink" href="#id204" title="Link to this heading">¶</a></h4>
+<section id="id209">
+<h4>Aliases<a class="headerlink" href="#id209" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_positions</p></li>
</ul>
@@ -7568,15 +7626,15 @@ an error will be returned.</p></li>
<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="id205">
-<h4>Arguments<a class="headerlink" href="#id205" title="Link to this heading">¶</a></h4>
+<section id="id210">
+<h4>Arguments<a class="headerlink" href="#id210" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>element</strong>: Element to append to the array.</p></li>
</ul>
</section>
-<section id="id206">
-<h4>Example<a class="headerlink" href="#id206" title="Link to this heading">¶</a></h4>
+<section id="id211">
+<h4>Example<a class="headerlink" href="#id211" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_append</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">],</span><span class="w"> </span><span class="mi">4</span><sp [...]
<span class="o">+</span><span class="c1">--------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_append</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">3</span><span class="p">]),</span><span class="n">Int64</span><span class="p">(</span><span class="mi">4</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -7586,8 +7644,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id207">
-<h4>Aliases<a class="headerlink" href="#id207" title="Link to this heading">¶</a></h4>
+<section id="id212">
+<h4>Aliases<a class="headerlink" href="#id212" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_prepend</p></li>
<li><p>array_push_front</p></li>
@@ -7609,15 +7667,15 @@ an error will be returned.</p></li>
<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="id208">
-<h4>Arguments<a class="headerlink" href="#id208" title="Link to this heading">¶</a></h4>
+<section id="id213">
+<h4>Arguments<a class="headerlink" href="#id213" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>element</strong>: Element to be removed from the array.</p></li>
</ul>
</section>
-<section id="id209">
-<h4>Example<a class="headerlink" href="#id209" title="Link to this heading">¶</a></h4>
+<section id="id214">
+<h4>Example<a class="headerlink" href="#id214" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_remove</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><spa [...]
<span class="o">+</span><span class="c1">----------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_remove</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">3</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">1</span><span class="p">,</span><span class="mi">4</span><span class="p [...]
@@ -7627,8 +7685,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id210">
-<h4>Aliases<a class="headerlink" href="#id210" title="Link to this heading">¶</a></h4>
+<section id="id215">
+<h4>Aliases<a class="headerlink" href="#id215" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_remove</p></li>
</ul>
@@ -7640,15 +7698,15 @@ an error will be returned.</p></li>
<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="id211">
-<h4>Arguments<a class="headerlink" href="#id211" title="Link to this heading">¶</a></h4>
+<section id="id216">
+<h4>Arguments<a class="headerlink" href="#id216" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>element</strong>: Element to be removed from the array.</p></li>
</ul>
</section>
-<section id="id212">
-<h4>Example<a class="headerlink" href="#id212" title="Link to this heading">¶</a></h4>
+<section id="id217">
+<h4>Example<a class="headerlink" href="#id217" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_remove</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><spa [...]
<span class="o">+</span><span class="c1">----------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_remove</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">3</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">1</span><span class="p">,</span><span class="mi">4</span><span class="p [...]
@@ -7658,8 +7716,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id213">
-<h4>Aliases<a class="headerlink" href="#id213" title="Link to this heading">¶</a></h4>
+<section id="id218">
+<h4>Aliases<a class="headerlink" href="#id218" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_remove_all</p></li>
</ul>
@@ -7671,15 +7729,15 @@ an error will be returned.</p></li>
<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="id214">
-<h4>Arguments<a class="headerlink" href="#id214" title="Link to this heading">¶</a></h4>
+<section id="id219">
+<h4>Arguments<a class="headerlink" href="#id219" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>element</strong>: Element to be removed from the array.</p></li>
</ul>
</section>
-<section id="id215">
-<h4>Example<a class="headerlink" href="#id215" title="Link to this heading">¶</a></h4>
+<section id="id220">
+<h4>Example<a class="headerlink" href="#id220" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_remove</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><spa [...]
<span class="o">+</span><span class="c1">----------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_remove</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">3</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">1</span><span class="p">,</span><span class="mi">4</span><span class="p [...]
@@ -7689,8 +7747,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id216">
-<h4>Aliases<a class="headerlink" href="#id216" title="Link to this heading">¶</a></h4>
+<section id="id221">
+<h4>Aliases<a class="headerlink" href="#id221" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_remove_n</p></li>
</ul>
@@ -7702,15 +7760,15 @@ an error will be returned.</p></li>
<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="id217">
-<h4>Arguments<a class="headerlink" href="#id217" title="Link to this heading">¶</a></h4>
+<section id="id222">
+<h4>Arguments<a class="headerlink" href="#id222" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>element</strong>: Element expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>count</strong>: Value of how many times to repeat the element.</p></li>
</ul>
</section>
-<section id="id218">
-<h4>Example<a class="headerlink" href="#id218" title="Link to this heading">¶</a></h4>
+<section id="id223">
+<h4>Example<a class="headerlink" href="#id223" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_repeat</span><span class="p">(</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">);</span>
<span class="o">+</span><span class="c1">---------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_repeat</span><span class="p">(</span><span class="n">Int64</span><span class="p">(</span><span class="mi">1</span><span class="p">),</span><span class="n">Int64</span><span class="p">(</span><span class="mi">3</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -7726,8 +7784,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id219">
-<h4>Aliases<a class="headerlink" href="#id219" title="Link to this heading">¶</a></h4>
+<section id="id224">
+<h4>Aliases<a class="headerlink" href="#id224" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_repeat</p></li>
</ul>
@@ -7739,8 +7797,8 @@ an error will be returned.</p></li>
<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="id220">
-<h4>Arguments<a class="headerlink" href="#id220" title="Link to this heading">¶</a></h4>
+<section id="id225">
+<h4>Arguments<a class="headerlink" href="#id225" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>from</strong>: Initial element.</p></li>
@@ -7748,8 +7806,8 @@ an error will be returned.</p></li>
<li><p><strong>max</strong>: Number of first occurrences to replace.</p></li>
</ul>
</section>
-<section id="id221">
-<h4>Example<a class="headerlink" href="#id221" title="Link to this heading">¶</a></h4>
+<section id="id226">
+<h4>Example<a class="headerlink" href="#id226" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_replace_n</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span>< [...]
<span class="o">+</span><span class="c1">-------------------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_replace_n</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">3</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">1</span><span class="p">,</span><span class="mi">4</span><span class [...]
@@ -7759,8 +7817,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id222">
-<h4>Aliases<a class="headerlink" href="#id222" title="Link to this heading">¶</a></h4>
+<section id="id227">
+<h4>Aliases<a class="headerlink" href="#id227" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_replace</p></li>
</ul>
@@ -7772,8 +7830,8 @@ an error will be returned.</p></li>
<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="id223">
-<h4>Arguments<a class="headerlink" href="#id223" title="Link to this heading">¶</a></h4>
+<section id="id228">
+<h4>Arguments<a class="headerlink" href="#id228" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>from</strong>: Initial element.</p></li>
@@ -7781,8 +7839,8 @@ an error will be returned.</p></li>
<li><p><strong>max</strong>: Number of first occurrences to replace.</p></li>
</ul>
</section>
-<section id="id224">
-<h4>Example<a class="headerlink" href="#id224" title="Link to this heading">¶</a></h4>
+<section id="id229">
+<h4>Example<a class="headerlink" href="#id229" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_replace_n</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span>< [...]
<span class="o">+</span><span class="c1">-------------------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_replace_n</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">3</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">1</span><span class="p">,</span><span class="mi">4</span><span class [...]
@@ -7792,8 +7850,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id225">
-<h4>Aliases<a class="headerlink" href="#id225" title="Link to this heading">¶</a></h4>
+<section id="id230">
+<h4>Aliases<a class="headerlink" href="#id230" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_replace_all</p></li>
</ul>
@@ -7805,8 +7863,8 @@ an error will be returned.</p></li>
<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="id226">
-<h4>Arguments<a class="headerlink" href="#id226" title="Link to this heading">¶</a></h4>
+<section id="id231">
+<h4>Arguments<a class="headerlink" href="#id231" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>from</strong>: Initial element.</p></li>
@@ -7814,8 +7872,8 @@ an error will be returned.</p></li>
<li><p><strong>max</strong>: Number of first occurrences to replace.</p></li>
</ul>
</section>
-<section id="id227">
-<h4>Example<a class="headerlink" href="#id227" title="Link to this heading">¶</a></h4>
+<section id="id232">
+<h4>Example<a class="headerlink" href="#id232" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_replace_n</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span>< [...]
<span class="o">+</span><span class="c1">-------------------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_replace_n</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">3</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">1</span><span class="p">,</span><span class="mi">4</span><span class [...]
@@ -7825,8 +7883,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id228">
-<h4>Aliases<a class="headerlink" href="#id228" title="Link to this heading">¶</a></h4>
+<section id="id233">
+<h4>Aliases<a class="headerlink" href="#id233" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_replace_n</p></li>
</ul>
@@ -7838,16 +7896,16 @@ an error will be returned.</p></li>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">array_resize</span><span class="p">(</span><span class="n">array</span><span class="p">,</span> <span class="n">size</span><span class="p">,</span> <span class="n">value</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id229">
-<h4>Arguments<a class="headerlink" href="#id229" title="Link to this heading">¶</a></h4>
+<section id="id234">
+<h4>Arguments<a class="headerlink" href="#id234" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>size</strong>: New size of given array.</p></li>
<li><p><strong>value</strong>: Defines new elements’ value or empty if value is not set.</p></li>
</ul>
</section>
-<section id="id230">
-<h4>Example<a class="headerlink" href="#id230" title="Link to this heading">¶</a></h4>
+<section id="id235">
+<h4>Example<a class="headerlink" href="#id235" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_resize</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">],</span><span class="w"> </span><span class="mi">5</span><sp [...]
<span class="o">+</span><span class="c1">-------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_resize</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">3</span><span class="p">],</span><span class="mi">5</span><span class="p">,</span><span class="mi">0</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -7857,8 +7915,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id231">
-<h4>Aliases<a class="headerlink" href="#id231" title="Link to this heading">¶</a></h4>
+<section id="id236">
+<h4>Aliases<a class="headerlink" href="#id236" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_resize</p></li>
</ul>
@@ -7870,14 +7928,14 @@ an error will be returned.</p></li>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">array_reverse</span><span class="p">(</span><span class="n">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id232">
-<h4>Arguments<a class="headerlink" href="#id232" title="Link to this heading">¶</a></h4>
+<section id="id237">
+<h4>Arguments<a class="headerlink" href="#id237" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
</ul>
</section>
-<section id="id233">
-<h4>Example<a class="headerlink" href="#id233" title="Link to this heading">¶</a></h4>
+<section id="id238">
+<h4>Example<a class="headerlink" href="#id238" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_reverse</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">,</span><span class="w"> </span><span class="mi">4</span><sp [...]
<span class="o">+</span><span class="c1">------------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_reverse</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">,</span><span class="w"> </span><span class="mi">4</span><span class="p">]))</span><span class="w"> </span><span class=" [...]
@@ -7887,8 +7945,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id234">
-<h4>Aliases<a class="headerlink" href="#id234" title="Link to this heading">¶</a></h4>
+<section id="id239">
+<h4>Aliases<a class="headerlink" href="#id239" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_reverse</p></li>
</ul>
@@ -7900,15 +7958,15 @@ an error will be returned.</p></li>
<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="id235">
-<h4>Arguments<a class="headerlink" href="#id235" title="Link to this heading">¶</a></h4>
+<section id="id240">
+<h4>Arguments<a class="headerlink" href="#id240" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>index</strong>: Index to extract the element from the array.</p></li>
</ul>
</section>
-<section id="id236">
-<h4>Example<a class="headerlink" href="#id236" title="Link to this heading">¶</a></h4>
+<section id="id241">
+<h4>Example<a class="headerlink" href="#id241" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_element</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">,</span><span class="w"> </span><span class="mi">4</span><sp [...]
<span class="o">+</span><span class="c1">-----------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_element</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">3</span><span class="p">,</span><span class="mi">4</span><span class="p">]),</span><span class="n">Int64</span><span class="p">(</span><span class="mi">3</span><span class="p">))</span><span class="w"> </span><span cl [...]
@@ -7918,8 +7976,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id237">
-<h4>Aliases<a class="headerlink" href="#id237" title="Link to this heading">¶</a></h4>
+<section id="id242">
+<h4>Aliases<a class="headerlink" href="#id242" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_slice</p></li>
</ul>
@@ -7931,16 +7989,16 @@ an error will be returned.</p></li>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">array_sort</span><span class="p">(</span><span class="n">array</span><span class="p">,</span> <span class="n">desc</span><span class="p">,</span> <span class="n">nulls_first</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id238">
-<h4>Arguments<a class="headerlink" href="#id238" title="Link to this heading">¶</a></h4>
+<section id="id243">
+<h4>Arguments<a class="headerlink" href="#id243" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>desc</strong>: Whether to sort in descending order(<code class="docutils literal notranslate"><span class="pre">ASC</span></code> or <code class="docutils literal notranslate"><span class="pre">DESC</span></code>).</p></li>
<li><p><strong>nulls_first</strong>: Whether to sort nulls first(<code class="docutils literal notranslate"><span class="pre">NULLS</span> <span class="pre">FIRST</span></code> or <code class="docutils literal notranslate"><span class="pre">NULLS</span> <span class="pre">LAST</span></code>).</p></li>
</ul>
</section>
-<section id="id239">
-<h4>Example<a class="headerlink" href="#id239" title="Link to this heading">¶</a></h4>
+<section id="id244">
+<h4>Example<a class="headerlink" href="#id244" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_sort</span><span class="p">([</span><span class="mi">3</span><span class="p">,</span><span class="w"> </span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">]);</span>
<span class="o">+</span><span class="c1">-----------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_sort</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">3</span><span class="p">,</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">]))</span><span class="w"> </span><span class="o">|</span>
@@ -7950,8 +8008,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id240">
-<h4>Aliases<a class="headerlink" href="#id240" title="Link to this heading">¶</a></h4>
+<section id="id245">
+<h4>Aliases<a class="headerlink" href="#id245" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_sort</p></li>
</ul>
@@ -7963,15 +8021,15 @@ an error will be returned.</p></li>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">array_to_string</span><span class="p">(</span><span class="n">array</span><span class="p">,</span> <span class="n">delimiter</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id241">
-<h4>Arguments<a class="headerlink" href="#id241" title="Link to this heading">¶</a></h4>
+<section id="id246">
+<h4>Arguments<a class="headerlink" href="#id246" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>delimiter</strong>: Array element separator.</p></li>
</ul>
</section>
-<section id="id242">
-<h4>Example<a class="headerlink" href="#id242" title="Link to this heading">¶</a></h4>
+<section id="id247">
+<h4>Example<a class="headerlink" href="#id247" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_to_string</span><span class="p">([[</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">,</span><span class="w"> </span><span class="mi">4</span> [...]
<span class="o">+</span><span class="c1">----------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_to_string</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">3</span><span class="p">,</span><span class="mi">4</span><span class="p">,</span><span class="mi">5</span><span class="p">,</span><span class="mi">6</span><span class="p">,</span><span class="mi">7</span><span class [...]
@@ -7981,8 +8039,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id243">
-<h4>Aliases<a class="headerlink" href="#id243" title="Link to this heading">¶</a></h4>
+<section id="id248">
+<h4>Aliases<a class="headerlink" href="#id248" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_to_string</p></li>
<li><p>array_join</p></li>
@@ -7996,14 +8054,14 @@ an error will be returned.</p></li>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">array_distinct</span><span class="p">(</span><span class="n">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id244">
-<h4>Arguments<a class="headerlink" href="#id244" title="Link to this heading">¶</a></h4>
+<section id="id249">
+<h4>Arguments<a class="headerlink" href="#id249" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
</ul>
</section>
-<section id="id245">
-<h4>Example<a class="headerlink" href="#id245" title="Link to this heading">¶</a></h4>
+<section id="id250">
+<h4>Example<a class="headerlink" href="#id250" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_distinct</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><s [...]
<span class="o">+</span><span class="c1">---------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_distinct</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">3</span><span class="p">,</span><span class="mi">4</span><span class="p">]))</span><span class="w"> </span><span class="o">|</span>
@@ -8013,8 +8071,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id246">
-<h4>Aliases<a class="headerlink" href="#id246" title="Link to this heading">¶</a></h4>
+<section id="id251">
+<h4>Aliases<a class="headerlink" href="#id251" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_union</p></li>
</ul>
@@ -8026,14 +8084,14 @@ an error will be returned.</p></li>
<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="id247">
-<h4>Arguments<a class="headerlink" href="#id247" title="Link to this heading">¶</a></h4>
+<section id="id252">
+<h4>Arguments<a class="headerlink" href="#id252" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
</ul>
</section>
-<section id="id248">
-<h4>Example<a class="headerlink" href="#id248" title="Link to this heading">¶</a></h4>
+<section id="id253">
+<h4>Example<a class="headerlink" href="#id253" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="k">cardinality</span><span class="p">([[</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">,</span><span class="w"> </span><span class="mi">4</span><spa [...]
<span class="o">+</span><span class="c1">--------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="k">cardinality</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">3</span><span class="p">,</span><span class="mi">4</span><span class="p">,</span><span class="mi">5</span><span class="p">,</span><span class="mi">6</span><span class="p">,</span><span class="mi">7</span><span class="p" [...]
@@ -8050,14 +8108,14 @@ an error will be returned.</p></li>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">empty</span><span class="p">(</span><span class="n">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id249">
-<h4>Arguments<a class="headerlink" href="#id249" title="Link to this heading">¶</a></h4>
+<section id="id254">
+<h4>Arguments<a class="headerlink" href="#id254" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
</ul>
</section>
-<section id="id250">
-<h4>Example<a class="headerlink" href="#id250" title="Link to this heading">¶</a></h4>
+<section id="id255">
+<h4>Example<a class="headerlink" href="#id255" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">empty</span><span class="p">([</span><span class="mi">1</span><span class="p">]);</span>
<span class="o">+</span><span class="c1">------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">empty</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">]))</span><span class="w"> </span><span class="o">|</span>
@@ -8067,8 +8125,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id251">
-<h4>Aliases<a class="headerlink" href="#id251" title="Link to this heading">¶</a></h4>
+<section id="id256">
+<h4>Aliases<a class="headerlink" href="#id256" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>array_empty</p></li>
<li><p>list_empty</p></li>
@@ -8086,14 +8144,14 @@ an error will be returned.</p></li>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">flatten</span><span class="p">(</span><span class="n">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id252">
-<h4>Arguments<a class="headerlink" href="#id252" title="Link to this heading">¶</a></h4>
+<section id="id257">
+<h4>Arguments<a class="headerlink" href="#id257" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
</ul>
</section>
-<section id="id253">
-<h4>Example<a class="headerlink" href="#id253" title="Link to this heading">¶</a></h4>
+<section id="id258">
+<h4>Example<a class="headerlink" href="#id258" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">flatten</span><span class="p">([[</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">],</span><span class="w"> </span><span class="p">[</span><span class="mi">3</span><span class="p">,</span><span class="w"> </span><span cl [...]
<span class="o">+</span><span class="c1">------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">flatten</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">],</span><span class="w"> </span><span class="p">[</span><span class="mi">3</span><span class="p">,</span><span class="mi">4</span><span class="p">]))</span><span class="w"> </span><span class="o">|</span>
@@ -8110,16 +8168,16 @@ an error will be returned.</p></li>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">generate_series</span><span class="p">(</span><span class="n">start</span><span class="p">,</span> <span class="n">stop</span><span class="p">,</span> <span class="n">step</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id254">
-<h4>Arguments<a class="headerlink" href="#id254" title="Link to this heading">¶</a></h4>
+<section id="id259">
+<h4>Arguments<a class="headerlink" href="#id259" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>start</strong>: start of the series. Ints, timestamps, dates or string types that can be coerced to Date32 are supported.</p></li>
<li><p><strong>end</strong>: end of the series (included). Type must be the same as start.</p></li>
<li><p><strong>step</strong>: increase by step (can not be 0). Steps less than a day are supported only for timestamp ranges.</p></li>
</ul>
</section>
-<section id="id255">
-<h4>Example<a class="headerlink" href="#id255" title="Link to this heading">¶</a></h4>
+<section id="id260">
+<h4>Example<a class="headerlink" href="#id260" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">generate_series</span><span class="p">(</span><span class="mi">1</span><span class="p">,</span><span class="mi">3</span><span class="p">);</span>
<span class="o">+</span><span class="c1">------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">generate_series</span><span class="p">(</span><span class="n">Int64</span><span class="p">(</span><span class="mi">1</span><span class="p">),</span><span class="n">Int64</span><span class="p">(</span><span class="mi">3</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -8296,14 +8354,14 @@ an error will be returned.</p></li>
<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="id256">
-<h4>Arguments<a class="headerlink" href="#id256" title="Link to this heading">¶</a></h4>
+<section id="id261">
+<h4>Arguments<a class="headerlink" href="#id261" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression_n</strong>: Expression to include in the output array. Can be a constant, column, or function, and any combination of arithmetic or string operators.</p></li>
</ul>
</section>
-<section id="id257">
-<h4>Example<a class="headerlink" href="#id257" title="Link to this heading">¶</a></h4>
+<section id="id262">
+<h4>Example<a class="headerlink" href="#id262" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">make_array</span><span class="p">(</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">,</span><span class="w"> </span><span class="mi">4</span><span c [...]
<span class="o">+</span><span class="c1">----------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">make_array</span><span class="p">(</span><span class="n">Int64</span><span class="p">(</span><span class="mi">1</span><span class="p">),</span><span class="n">Int64</span><span class="p">(</span><span class="mi">2</span><span class="p">),</span><span class="n">Int64</span><span class="p">(</span><span class="mi">3</span><span class="p">),</span><span class="n">Int64</span><span class="p">(</span><span class="mi">4</span><spa [...]
@@ -8313,8 +8371,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id258">
-<h4>Aliases<a class="headerlink" href="#id258" title="Link to this heading">¶</a></h4>
+<section id="id263">
+<h4>Aliases<a class="headerlink" href="#id263" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>make_list</p></li>
</ul>
@@ -8330,16 +8388,16 @@ an error will be returned.</p></li>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="nb">range</span><span class="p">(</span><span class="n">start</span><span class="p">,</span> <span class="n">stop</span><span class="p">,</span> <span class="n">step</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id259">
-<h4>Arguments<a class="headerlink" href="#id259" title="Link to this heading">¶</a></h4>
+<section id="id264">
+<h4>Arguments<a class="headerlink" href="#id264" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>start</strong>: Start of the range. Ints, timestamps, dates or string types that can be coerced to Date32 are supported.</p></li>
<li><p><strong>end</strong>: End of the range (not included). Type must be the same as start.</p></li>
<li><p><strong>step</strong>: Increase by step (cannot be 0). Steps less than a day are supported only for timestamp ranges.</p></li>
</ul>
</section>
-<section id="id260">
-<h4>Example<a class="headerlink" href="#id260" title="Link to this heading">¶</a></h4>
+<section id="id265">
+<h4>Example<a class="headerlink" href="#id265" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">range</span><span class="p">(</span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">10</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">);</span>
<span class="o">+</span><span class="c1">-----------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">range</span><span class="p">(</span><span class="n">Int64</span><span class="p">(</span><span class="mi">2</span><span class="p">),</span><span class="n">Int64</span><span class="p">(</span><span class="mi">10</span><span class="p">),</span><span class="n">Int64</span><span class="p">(</span><span class="mi">3</span><span class="p">))</span><span class="o">|</span>
@@ -8363,15 +8421,15 @@ an error will be returned.</p></li>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">array_to_string</span><span class="p">(</span><span class="n">array</span><span class="p">,</span> <span class="n">delimiter</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id261">
-<h4>Arguments<a class="headerlink" href="#id261" title="Link to this heading">¶</a></h4>
+<section id="id266">
+<h4>Arguments<a class="headerlink" href="#id266" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>delimiter</strong>: Array element separator.</p></li>
</ul>
</section>
-<section id="id262">
-<h4>Example<a class="headerlink" href="#id262" title="Link to this heading">¶</a></h4>
+<section id="id267">
+<h4>Example<a class="headerlink" href="#id267" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">array_to_string</span><span class="p">([[</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">,</span><span class="w"> </span><span class="mi">4</span> [...]
<span class="o">+</span><span class="c1">----------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">array_to_string</span><span class="p">(</span><span class="n">List</span><span class="p">([</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">,</span><span class="mi">3</span><span class="p">,</span><span class="mi">4</span><span class="p">,</span><span class="mi">5</span><span class="p">,</span><span class="mi">6</span><span class="p">,</span><span class="mi">7</span><span class [...]
@@ -8381,8 +8439,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id263">
-<h4>Aliases<a class="headerlink" href="#id263" title="Link to this heading">¶</a></h4>
+<section id="id268">
+<h4>Aliases<a class="headerlink" href="#id268" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>string_to_list</p></li>
</ul>
@@ -8406,15 +8464,15 @@ an error will be returned.</p></li>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">named_struct</span><span class="p">(</span><span class="n">expression1_name</span><span class="p">,</span> <span class="n">expression1_input</span><span class="p">[,</span> <span class="o">...</span><span class="p">,</span> <span class="n">expression_n_name</span><span class="p">,</span> <span class="n">expression_n_input</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id264">
-<h4>Arguments<a class="headerlink" href="#id264" title="Link to this heading">¶</a></h4>
+<section id="id269">
+<h4>Arguments<a class="headerlink" href="#id269" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression_n_name</strong>: Name of the column field. Must be a constant string.</p></li>
<li><p><strong>expression_n_input</strong>: Expression to include in the output struct. Can be a constant, column, or function, and any combination of arithmetic or string operators.</p></li>
</ul>
</section>
-<section id="id265">
-<h4>Example<a class="headerlink" href="#id265" title="Link to this heading">¶</a></h4>
+<section id="id270">
+<h4>Example<a class="headerlink" href="#id270" title="Link to this heading">¶</a></h4>
<p>For example, this query converts two columns <code class="docutils literal notranslate"><span class="pre">a</span></code> and <code class="docutils literal notranslate"><span class="pre">b</span></code> to a single column with
a struct type of fields <code class="docutils literal notranslate"><span class="pre">field_a</span></code> and <code class="docutils literal notranslate"><span class="pre">field_b</span></code>:</p>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="o">*</span><span class="w"> </span><span class="k">from</span><span class="w"> </span><span class="n">t</span><span class="p">;</span>
@@ -8447,14 +8505,14 @@ For example: <code class="docutils literal notranslate"><span class="pre">c0</sp
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">struct</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="id266">
-<h4>Arguments<a class="headerlink" href="#id266" title="Link to this heading">¶</a></h4>
+<section id="id271">
+<h4>Arguments<a class="headerlink" href="#id271" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression1, expression_n</strong>: Expression to include in the output struct. Can be a constant, column, or function, any combination of arithmetic or string operators.</p></li>
</ul>
</section>
-<section id="id267">
-<h4>Example<a class="headerlink" href="#id267" title="Link to this heading">¶</a></h4>
+<section id="id272">
+<h4>Example<a class="headerlink" href="#id272" title="Link to this heading">¶</a></h4>
<p>For example, this query converts two columns <code class="docutils literal notranslate"><span class="pre">a</span></code> and <code class="docutils literal notranslate"><span class="pre">b</span></code> to a single column with
a struct type of fields <code class="docutils literal notranslate"><span class="pre">field_a</span></code> and <code class="docutils literal notranslate"><span class="pre">c1</span></code>:</p>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="o">*</span><span class="w"> </span><span class="k">from</span><span class="w"> </span><span class="n">t</span><span class="p">;</span>
@@ -8485,8 +8543,8 @@ a struct type of fields <code class="docutils literal notranslate"><span class="
</pre></div>
</div>
</section>
-<section id="id268">
-<h4>Aliases<a class="headerlink" href="#id268" title="Link to this heading">¶</a></h4>
+<section id="id273">
+<h4>Aliases<a class="headerlink" href="#id273" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>row</p></li>
</ul>
@@ -8515,8 +8573,8 @@ a struct type of fields <code class="docutils literal notranslate"><span class="
<span class="n">make_map</span><span class="p">([</span><span class="s1">'key1'</span><span class="p">,</span> <span class="s1">'key2'</span><span class="p">],</span> <span class="p">[</span><span class="s1">'value1'</span><span class="p">,</span> <span class="s1">'value2'</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id269">
-<h4>Arguments<a class="headerlink" href="#id269" title="Link to this heading">¶</a></h4>
+<section id="id274">
+<h4>Arguments<a class="headerlink" href="#id274" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>key</strong>: For <code class="docutils literal notranslate"><span class="pre">map</span></code>: Expression to be used for key. Can be a constant, column, function, or any combination of arithmetic or string operators.
For <code class="docutils literal notranslate"><span class="pre">make_map</span></code>: The list of keys to be used in the map. Each key must be unique and non-null.</p></li>
@@ -8524,8 +8582,8 @@ For <code class="docutils literal notranslate"><span class="pre">make_map</span>
For <code class="docutils literal notranslate"><span class="pre">make_map</span></code>: The list of values to be mapped to the corresponding keys.</p></li>
</ul>
</section>
-<section id="id270">
-<h4>Example<a class="headerlink" href="#id270" title="Link to this heading">¶</a></h4>
+<section id="id275">
+<h4>Example<a class="headerlink" href="#id275" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="w"> </span><span class="c1">-- Using map function</span>
<span class="w"> </span><span class="k">SELECT</span><span class="w"> </span><span class="k">MAP</span><span class="p">(</span><span class="s1">'type'</span><span class="p">,</span><span class="w"> </span><span class="s1">'test'</span><span class="p">);</span>
<span class="w"> </span><span class="c1">----</span>
@@ -8582,8 +8640,8 @@ SELECT map_extract(MAP {'x': 10, 'y': NULL, 'z': 30}, &#
</pre></div>
</div>
</section>
-<section id="id271">
-<h4>Aliases<a class="headerlink" href="#id271" title="Link to this heading">¶</a></h4>
+<section id="id276">
+<h4>Aliases<a class="headerlink" href="#id276" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>element_at</p></li>
</ul>
@@ -8595,14 +8653,14 @@ SELECT map_extract(MAP {'x': 10, 'y': NULL, 'z': 30}, &#
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">map_keys</span><span class="p">(</span><span class="nb">map</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id272">
-<h4>Arguments<a class="headerlink" href="#id272" title="Link to this heading">¶</a></h4>
+<section id="id277">
+<h4>Arguments<a class="headerlink" href="#id277" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>map</strong>: Map expression. Can be a constant, column, or function, and any combination of map operators.</p></li>
</ul>
</section>
-<section id="id273">
-<h4>Example<a class="headerlink" href="#id273" title="Link to this heading">¶</a></h4>
+<section id="id278">
+<h4>Example<a class="headerlink" href="#id278" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">SELECT</span><span class="w"> </span><span class="n">map_keys</span><span class="p">(</span><span class="k">MAP</span><span class="w"> </span><span class="err">{</span><span class="s1">'a'</span><span class="p">:</span><span class="w"> </span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="s1">'b'</span><span class="p">:</span><span class=" [...]
<span class="c1">----</span>
<span class="p">[</span><span class="n">a</span><span class="p">,</span><span class="w"> </span><span class="n">b</span><span class="p">,</span><span class="w"> </span><span class="k">c</span><span class="p">]</span>
@@ -8620,14 +8678,14 @@ SELECT map_extract(MAP {'x': 10, 'y': NULL, 'z': 30}, &#
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">map_values</span><span class="p">(</span><span class="nb">map</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id274">
-<h4>Arguments<a class="headerlink" href="#id274" title="Link to this heading">¶</a></h4>
+<section id="id279">
+<h4>Arguments<a class="headerlink" href="#id279" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>map</strong>: Map expression. Can be a constant, column, or function, and any combination of map operators.</p></li>
</ul>
</section>
-<section id="id275">
-<h4>Example<a class="headerlink" href="#id275" title="Link to this heading">¶</a></h4>
+<section id="id280">
+<h4>Example<a class="headerlink" href="#id280" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">SELECT</span><span class="w"> </span><span class="n">map_values</span><span class="p">(</span><span class="k">MAP</span><span class="w"> </span><span class="err">{</span><span class="s1">'a'</span><span class="p">:</span><span class="w"> </span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="s1">'b'</span><span class="p">:</span><span class [...]
<span class="c1">----</span>
<span class="p">[</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">]</span>
@@ -8656,8 +8714,8 @@ SELECT map_extract(MAP {'x': 10, 'y': NULL, 'z': 30}, &#
<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="id276">
-<h4>Arguments<a class="headerlink" href="#id276" title="Link to this heading">¶</a></h4>
+<section id="id281">
+<h4>Arguments<a class="headerlink" href="#id281" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>algorithm</strong>: String expression specifying algorithm to use. Must be one of:</p></li>
@@ -8671,8 +8729,8 @@ SELECT map_extract(MAP {'x': 10, 'y': NULL, 'z': 30}, &#
<li><p>blake3</p></li>
</ul>
</section>
-<section id="id277">
-<h4>Example<a class="headerlink" href="#id277" title="Link to this heading">¶</a></h4>
+<section id="id282">
+<h4>Example<a class="headerlink" href="#id282" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">digest</span><span class="p">(</span><span class="s1">'foo'</span><span class="p">,</span><span class="w"> </span><span class="s1">'sha256'</span><span class="p">);</span>
<span class="o">+</span><span class="c1">------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">digest</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"foo"</span><span class="p">),</span><span class="w"> </span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"sha256"</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -8689,14 +8747,14 @@ SELECT map_extract(MAP {'x': 10, 'y': NULL, 'z': 30}, &#
<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="id278">
-<h4>Arguments<a class="headerlink" href="#id278" title="Link to this heading">¶</a></h4>
+<section id="id283">
+<h4>Arguments<a class="headerlink" href="#id283" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id279">
-<h4>Example<a class="headerlink" href="#id279" title="Link to this heading">¶</a></h4>
+<section id="id284">
+<h4>Example<a class="headerlink" href="#id284" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">md5</span><span class="p">(</span><span class="s1">'foo'</span><span class="p">);</span>
<span class="o">+</span><span class="c1">-------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">md5</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"foo"</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -8713,14 +8771,14 @@ SELECT map_extract(MAP {'x': 10, 'y': NULL, 'z': 30}, &#
<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="id280">
-<h4>Arguments<a class="headerlink" href="#id280" title="Link to this heading">¶</a></h4>
+<section id="id285">
+<h4>Arguments<a class="headerlink" href="#id285" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id281">
-<h4>Example<a class="headerlink" href="#id281" title="Link to this heading">¶</a></h4>
+<section id="id286">
+<h4>Example<a class="headerlink" href="#id286" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">sha224</span><span class="p">(</span><span class="s1">'foo'</span><span class="p">);</span>
<span class="o">+</span><span class="c1">------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">sha224</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"foo"</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -8737,14 +8795,14 @@ SELECT map_extract(MAP {'x': 10, 'y': NULL, 'z': 30}, &#
<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="id282">
-<h4>Arguments<a class="headerlink" href="#id282" title="Link to this heading">¶</a></h4>
+<section id="id287">
+<h4>Arguments<a class="headerlink" href="#id287" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id283">
-<h4>Example<a class="headerlink" href="#id283" title="Link to this heading">¶</a></h4>
+<section id="id288">
+<h4>Example<a class="headerlink" href="#id288" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">sha256</span><span class="p">(</span><span class="s1">'foo'</span><span class="p">);</span>
<span class="o">+</span><span class="c1">--------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">sha256</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"foo"</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -8761,14 +8819,14 @@ SELECT map_extract(MAP {'x': 10, 'y': NULL, 'z': 30}, &#
<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="id284">
-<h4>Arguments<a class="headerlink" href="#id284" title="Link to this heading">¶</a></h4>
+<section id="id289">
+<h4>Arguments<a class="headerlink" href="#id289" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id285">
-<h4>Example<a class="headerlink" href="#id285" title="Link to this heading">¶</a></h4>
+<section id="id290">
+<h4>Example<a class="headerlink" href="#id290" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">sha384</span><span class="p">(</span><span class="s1">'foo'</span><span class="p">);</span>
<span class="o">+</span><span class="c1">-----------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">sha384</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"foo"</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -8785,14 +8843,14 @@ SELECT map_extract(MAP {'x': 10, 'y': NULL, 'z': 30}, &#
<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="id286">
-<h4>Arguments<a class="headerlink" href="#id286" title="Link to this heading">¶</a></h4>
+<section id="id291">
+<h4>Arguments<a class="headerlink" href="#id291" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String</p></li>
</ul>
</section>
-<section id="id287">
-<h4>Example<a class="headerlink" href="#id287" title="Link to this heading">¶</a></h4>
+<section id="id292">
+<h4>Example<a class="headerlink" href="#id292" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">sha512</span><span class="p">(</span><span class="s1">'foo'</span><span class="p">);</span>
<span class="o">+</span><span class="c1">-------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">sha512</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"foo"</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
@@ -8818,15 +8876,15 @@ SELECT map_extract(MAP {'x': 10, 'y': NULL, 'z': 30}, &#
<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="id288">
-<h4>Arguments<a class="headerlink" href="#id288" title="Link to this heading">¶</a></h4>
+<section id="id293">
+<h4>Arguments<a class="headerlink" href="#id293" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to cast. The expression can be a constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>datatype</strong>: <a class="reference external" href="https://docs.rs/arrow/latest/arrow/datatypes/enum.DataType.html">Arrow data type</a> name to cast to, as a string. The format is the same as that returned by [<code class="docutils literal notranslate"><span class="pre">arrow_typeof</span></code>]</p></li>
</ul>
</section>
-<section id="id289">
-<h4>Example<a class="headerlink" href="#id289" title="Link to this heading">¶</a></h4>
+<section id="id294">
+<h4>Example<a class="headerlink" href="#id294" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">arrow_cast</span><span class="p">(</span><span class="o">-</span><span class="mi">5</span><span class="p">,</span><span class="w"> </span><span class="s1">'Int8'</span><span class="p">)</span><span class="w"> </span><span class="k">as</span><span class="w"> </span><span class="n">a</ [...]
<span class="w"> </span><span class="n">arrow_cast</span><span class="p">(</span><span class="s1">'foo'</span><span class="p">,</span><span class="w"> </span><span class="s1">'Dictionary(Int32, Utf8)'</span><span class="p">)</span><span class="w"> </span><span class="k">as</span><span class="w"> </span><span class="n">b</span><span class="p">,</span>
<span class="w"> </span><span class="n">arrow_cast</span><span class="p">(</span><span class="s1">'bar'</span><span class="p">,</span><span class="w"> </span><span class="s1">'LargeUtf8'</span><span class="p">)</span><span class="w"> </span><span class="k">as</span><span class="w"> </span><span class="k">c</span><span class="p">,</span>
@@ -8847,14 +8905,14 @@ SELECT map_extract(MAP {'x': 10, 'y': NULL, 'z': 30}, &#
<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="id290">
-<h4>Arguments<a class="headerlink" href="#id290" title="Link to this heading">¶</a></h4>
+<section id="id295">
+<h4>Arguments<a class="headerlink" href="#id295" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to evaluate. The expression can be a constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id291">
-<h4>Example<a class="headerlink" href="#id291" title="Link to this heading">¶</a></h4>
+<section id="id296">
+<h4>Example<a class="headerlink" href="#id296" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">arrow_typeof</span><span class="p">(</span><span class="s1">'foo'</span><span class="p">),</span><span class="w"> </span><span class="n">arrow_typeof</span><span class="p">(</span><span class="mi">1</span><span class="p">);</span>
<span class="o">+</span><span class="c1">---------------------------+------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">arrow_typeof</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"foo"</span><span class="p">))</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">arrow_typeof</span><span class="p">(</span><span class="n">Int64</span><span class="p">(</span><span class="mi">1</span><span class="p">))</span><span class="w"> </span><span class=" [...]
@@ -8874,15 +8932,15 @@ syntax such as <code class="docutils literal notranslate"><span class="pre">my_s
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">get_field</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="id292">
-<h4>Arguments<a class="headerlink" href="#id292" title="Link to this heading">¶</a></h4>
+<section id="id297">
+<h4>Arguments<a class="headerlink" href="#id297" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression1</strong>: The map or struct to retrieve a field for.</p></li>
<li><p><strong>expression2</strong>: The field name in the map or struct to retrieve data for. Must evaluate to a string.</p></li>
</ul>
</section>
-<section id="id293">
-<h4>Example<a class="headerlink" href="#id293" title="Link to this heading">¶</a></h4>
+<section id="id298">
+<h4>Example<a class="headerlink" href="#id298" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">create</span><span class="w"> </span><span class="k">table</span><span class="w"> </span><span class="n">t</span><span class="w"> </span><span class="p">(</span><span class="n">idx</span><span class="w"> </span><span class="nb">varchar</span><span class="p">,</span><span class="w"> </span><span class="n">v</span><span class="w"> </span><span c [...]
<span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">struct</span><span class="p">(</span><span class="n">idx</span><span class="p">,</span><span class="w"> </span><span class="n">v</span><span class="p">)</span><span class="w"> </span><span class="k">from</span><span class="w"> </span><span class="n">t</span><span class="w"> </span><span class="k">as</span><span class="w"> </span><span class="k">c</span><span class="p">;</span>
<span class="o">+</span><span class="c1">-------------------------+</span>
@@ -8915,8 +8973,8 @@ syntax such as <code class="docutils literal notranslate"><span class="pre">my_s
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">version</span><span class="p">()</span>
</pre></div>
</div>
-<section id="id294">
-<h4>Example<a class="headerlink" href="#id294" title="Link to this heading">¶</a></h4>
+<section id="id299">
+<h4>Example<a class="headerlink" href="#id299" title="Link to this heading">¶</a></h4>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="o">></span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="k">version</span><span class="p">();</span>
<span class="o">+</span><span class="c1">--------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="k">version</span><span class="p">()</span><span class="w"> </span><span class="o">|</span>
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@datafusion.apache.org
For additional commands, e-mail: commits-help@datafusion.apache.org