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/11/04 11:49:54 UTC
(datafusion) branch asf-site updated: Publish built docs triggered by d19865ee80ee6434694b8dc9cd00c8cae52c6fc7
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 e1d2f0c3db Publish built docs triggered by d19865ee80ee6434694b8dc9cd00c8cae52c6fc7
e1d2f0c3db is described below
commit e1d2f0c3dbe748a6a81db70386862d306a3b2103
Author: github-actions[bot] <gi...@users.noreply.github.com>
AuthorDate: Mon Nov 4 11:49:49 2024 +0000
Publish built docs triggered by d19865ee80ee6434694b8dc9cd00c8cae52c6fc7
---
_sources/user-guide/sql/scalar_functions.md.txt | 16 +-
searchindex.js | 2 +-
user-guide/sql/scalar_functions.html | 1017 ++++++++++++-----------
3 files changed, 532 insertions(+), 503 deletions(-)
diff --git a/_sources/user-guide/sql/scalar_functions.md.txt b/_sources/user-guide/sql/scalar_functions.md.txt
index 98c44cbd98..b92b815d7c 100644
--- a/_sources/user-guide/sql/scalar_functions.md.txt
+++ b/_sources/user-guide/sql/scalar_functions.md.txt
@@ -2037,12 +2037,24 @@ _Alias of [date_trunc](#date_trunc)._
Converts an integer to RFC3339 timestamp format (`YYYY-MM-DDT00:00:00.000000000Z`). Integers and unsigned integers are interpreted as nanoseconds since the unix epoch (`1970-01-01T00:00:00Z`) return the corresponding timestamp.
```
-from_unixtime(expression)
+from_unixtime(expression[, timezone])
```
#### Arguments
-- **expression**: Expression to operate on. Can be a constant, column, or function, and any combination of arithmetic operators.
+- **expression**: The expression to operate on. Can be a constant, column, or function, and any combination of operators.
+- **timezone**: Optional timezone to use when converting the integer to a timestamp. If not provided, the default timezone is UTC.
+
+#### Example
+
+```sql
+> select from_unixtime(1599572549, 'America/New_York');
++-----------------------------------------------------------+
+| from_unixtime(Int64(1599572549),Utf8("America/New_York")) |
++-----------------------------------------------------------+
+| 2020-09-08T09:42:29-04:00 |
++-----------------------------------------------------------+
+```
### `make_date`
diff --git a/searchindex.js b/searchindex.js
index c04e19b21a..13be1a64eb 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"alltitles": {"!=": [[47, "op-neq"]], "!~": [[47, "op-re-not-match"]], "!~*": [[47, "op-re-not-match-i"]], "!~~": [[47, "id18"]], "!~~*": [[47, "id19"]], "#": [[47, "op-bit-xor"]], "%": [[47, "op-modulo"]], "&": [[47, "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"]], "*": [[47, "op-multiply"]], "+": [[47, "op-plus"]], "-": [[47, "op-minus"]], "/": [[4 [...]
\ No newline at end of file
+Search.setIndex({"alltitles": {"!=": [[47, "op-neq"]], "!~": [[47, "op-re-not-match"]], "!~*": [[47, "op-re-not-match-i"]], "!~~": [[47, "id18"]], "!~~*": [[47, "id19"]], "#": [[47, "op-bit-xor"]], "%": [[47, "op-modulo"]], "&": [[47, "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"]], "*": [[47, "op-multiply"]], "+": [[47, "op-plus"]], "-": [[47, "op-minus"]], "/": [[4 [...]
\ No newline at end of file
diff --git a/user-guide/sql/scalar_functions.html b/user-guide/sql/scalar_functions.html
index 005c5d1a04..7db3d6e371 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -2283,6 +2283,11 @@
Arguments
</a>
</li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id134">
+ Example
+ </a>
+ </li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
@@ -2295,12 +2300,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id134">
+ <a class="reference internal nav-link" href="#id135">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id135">
+ <a class="reference internal nav-link" href="#id136">
Example
</a>
</li>
@@ -2316,7 +2321,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id136">
+ <a class="reference internal nav-link" href="#id137">
Aliases
</a>
</li>
@@ -2332,17 +2337,17 @@
</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="#id138">
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="#id139">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id139">
+ <a class="reference internal nav-link" href="#id140">
Aliases
</a>
</li>
@@ -2358,12 +2363,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id140">
+ <a class="reference internal nav-link" href="#id141">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id141">
+ <a class="reference internal nav-link" href="#id142">
Example
</a>
</li>
@@ -2379,12 +2384,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id142">
+ <a class="reference internal nav-link" href="#id143">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id143">
+ <a class="reference internal nav-link" href="#id144">
Example
</a>
</li>
@@ -2400,12 +2405,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id144">
+ <a class="reference internal nav-link" href="#id145">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id145">
+ <a class="reference internal nav-link" href="#id146">
Example
</a>
</li>
@@ -2421,12 +2426,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id146">
+ <a class="reference internal nav-link" href="#id147">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id147">
+ <a class="reference internal nav-link" href="#id148">
Example
</a>
</li>
@@ -2442,12 +2447,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id148">
+ <a class="reference internal nav-link" href="#id149">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id149">
+ <a class="reference internal nav-link" href="#id150">
Example
</a>
</li>
@@ -2463,12 +2468,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id150">
+ <a class="reference internal nav-link" href="#id151">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id151">
+ <a class="reference internal nav-link" href="#id152">
Example
</a>
</li>
@@ -2484,12 +2489,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id152">
+ <a class="reference internal nav-link" href="#id153">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id153">
+ <a class="reference internal nav-link" href="#id154">
Example
</a>
</li>
@@ -2505,12 +2510,12 @@
</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="#id155">
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="#id156">
Example
</a>
</li>
@@ -2542,17 +2547,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id156">
+ <a class="reference internal nav-link" href="#id157">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id157">
+ <a class="reference internal nav-link" href="#id158">
Example
</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="#id159">
Aliases
</a>
</li>
@@ -2568,17 +2573,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id159">
+ <a class="reference internal nav-link" href="#id160">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id160">
+ <a class="reference internal nav-link" href="#id161">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id161">
+ <a class="reference internal nav-link" href="#id162">
Aliases
</a>
</li>
@@ -2603,17 +2608,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id162">
+ <a class="reference internal nav-link" href="#id163">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id163">
+ <a class="reference internal nav-link" href="#id164">
Example
</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="#id165">
Aliases
</a>
</li>
@@ -2638,17 +2643,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id165">
+ <a class="reference internal nav-link" href="#id166">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id166">
+ <a class="reference internal nav-link" href="#id167">
Example
</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="#id168">
Aliases
</a>
</li>
@@ -2664,17 +2669,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id168">
+ <a class="reference internal nav-link" href="#id169">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id169">
+ <a class="reference internal nav-link" href="#id170">
Example
</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="#id171">
Aliases
</a>
</li>
@@ -2690,17 +2695,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id171">
+ <a class="reference internal nav-link" href="#id172">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id172">
+ <a class="reference internal nav-link" href="#id173">
Example
</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="#id174">
Aliases
</a>
</li>
@@ -2716,17 +2721,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id174">
+ <a class="reference internal nav-link" href="#id175">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id175">
+ <a class="reference internal nav-link" href="#id176">
Example
</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="#id177">
Aliases
</a>
</li>
@@ -2751,17 +2756,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id177">
+ <a class="reference internal nav-link" href="#id178">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id178">
+ <a class="reference internal nav-link" href="#id179">
Example
</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="#id180">
Aliases
</a>
</li>
@@ -2786,17 +2791,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id180">
+ <a class="reference internal nav-link" href="#id181">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id181">
+ <a class="reference internal nav-link" href="#id182">
Example
</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="#id183">
Aliases
</a>
</li>
@@ -2812,17 +2817,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id183">
+ <a class="reference internal nav-link" href="#id184">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id184">
+ <a class="reference internal nav-link" href="#id185">
Example
</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="#id186">
Aliases
</a>
</li>
@@ -2838,17 +2843,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id186">
+ <a class="reference internal nav-link" href="#id187">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id187">
+ <a class="reference internal nav-link" href="#id188">
Example
</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="#id189">
Aliases
</a>
</li>
@@ -2873,17 +2878,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id189">
+ <a class="reference internal nav-link" href="#id190">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id190">
+ <a class="reference internal nav-link" href="#id191">
Example
</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="#id192">
Aliases
</a>
</li>
@@ -2908,17 +2913,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id192">
+ <a class="reference internal nav-link" href="#id193">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id193">
+ <a class="reference internal nav-link" href="#id194">
Example
</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="#id195">
Aliases
</a>
</li>
@@ -2934,17 +2939,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id195">
+ <a class="reference internal nav-link" href="#id196">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id196">
+ <a class="reference internal nav-link" href="#id197">
Example
</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="#id198">
Aliases
</a>
</li>
@@ -2960,17 +2965,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id198">
+ <a class="reference internal nav-link" href="#id199">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id199">
+ <a class="reference internal nav-link" href="#id200">
Example
</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="#id201">
Aliases
</a>
</li>
@@ -2986,17 +2991,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id201">
+ <a class="reference internal nav-link" href="#id202">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id202">
+ <a class="reference internal nav-link" href="#id203">
Example
</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="#id204">
Aliases
</a>
</li>
@@ -3012,17 +3017,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id204">
+ <a class="reference internal nav-link" href="#id205">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id205">
+ <a class="reference internal nav-link" href="#id206">
Example
</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="#id207">
Aliases
</a>
</li>
@@ -3038,17 +3043,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id207">
+ <a class="reference internal nav-link" href="#id208">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id208">
+ <a class="reference internal nav-link" href="#id209">
Example
</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="#id210">
Aliases
</a>
</li>
@@ -3064,17 +3069,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id210">
+ <a class="reference internal nav-link" href="#id211">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id211">
+ <a class="reference internal nav-link" href="#id212">
Example
</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="#id213">
Aliases
</a>
</li>
@@ -3108,17 +3113,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id213">
+ <a class="reference internal nav-link" href="#id214">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id214">
+ <a class="reference internal nav-link" href="#id215">
Example
</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="#id216">
Aliases
</a>
</li>
@@ -3134,17 +3139,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id216">
+ <a class="reference internal nav-link" href="#id217">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id217">
+ <a class="reference internal nav-link" href="#id218">
Example
</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="#id219">
Aliases
</a>
</li>
@@ -3160,17 +3165,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id219">
+ <a class="reference internal nav-link" href="#id220">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id220">
+ <a class="reference internal nav-link" href="#id221">
Example
</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="#id222">
Aliases
</a>
</li>
@@ -3186,17 +3191,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id222">
+ <a class="reference internal nav-link" href="#id223">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id223">
+ <a class="reference internal nav-link" href="#id224">
Example
</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="#id225">
Aliases
</a>
</li>
@@ -3212,17 +3217,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id225">
+ <a class="reference internal nav-link" href="#id226">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id226">
+ <a class="reference internal nav-link" href="#id227">
Example
</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="#id228">
Aliases
</a>
</li>
@@ -3238,17 +3243,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id228">
+ <a class="reference internal nav-link" href="#id229">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id229">
+ <a class="reference internal nav-link" href="#id230">
Example
</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="#id231">
Aliases
</a>
</li>
@@ -3264,17 +3269,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id231">
+ <a class="reference internal nav-link" href="#id232">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id232">
+ <a class="reference internal nav-link" href="#id233">
Example
</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="#id234">
Aliases
</a>
</li>
@@ -3290,17 +3295,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id234">
+ <a class="reference internal nav-link" href="#id235">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id235">
+ <a class="reference internal nav-link" href="#id236">
Example
</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="#id237">
Aliases
</a>
</li>
@@ -3316,17 +3321,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id237">
+ <a class="reference internal nav-link" href="#id238">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id238">
+ <a class="reference internal nav-link" href="#id239">
Example
</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="#id240">
Aliases
</a>
</li>
@@ -3342,17 +3347,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id240">
+ <a class="reference internal nav-link" href="#id241">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id241">
+ <a class="reference internal nav-link" href="#id242">
Example
</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="#id243">
Aliases
</a>
</li>
@@ -3368,17 +3373,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id243">
+ <a class="reference internal nav-link" href="#id244">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id244">
+ <a class="reference internal nav-link" href="#id245">
Example
</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="#id246">
Aliases
</a>
</li>
@@ -3394,17 +3399,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id246">
+ <a class="reference internal nav-link" href="#id247">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id247">
+ <a class="reference internal nav-link" href="#id248">
Example
</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="#id249">
Aliases
</a>
</li>
@@ -3420,17 +3425,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="#id250">
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="#id251">
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="#id252">
Aliases
</a>
</li>
@@ -3446,12 +3451,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="#id253">
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="#id254">
Example
</a>
</li>
@@ -3467,17 +3472,17 @@
</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="#id255">
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="#id256">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id256">
+ <a class="reference internal nav-link" href="#id257">
Aliases
</a>
</li>
@@ -3493,12 +3498,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id257">
+ <a class="reference internal nav-link" href="#id258">
Arguments
</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="#id259">
Example
</a>
</li>
@@ -3514,12 +3519,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="#id260">
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="#id261">
Example
</a>
</li>
@@ -3895,17 +3900,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="#id262">
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="#id263">
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="#id264">
Aliases
</a>
</li>
@@ -3930,12 +3935,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="#id265">
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="#id266">
Example
</a>
</li>
@@ -3951,17 +3956,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="#id267">
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="#id268">
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="#id269">
Aliases
</a>
</li>
@@ -3993,12 +3998,12 @@
</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="#id270">
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="#id271">
Example
</a>
</li>
@@ -4023,17 +4028,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id271">
+ <a class="reference internal nav-link" href="#id272">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id272">
+ <a class="reference internal nav-link" href="#id273">
Example
</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="#id274">
Aliases
</a>
</li>
@@ -4065,17 +4070,17 @@
</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="#id275">
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="#id276">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id276">
+ <a class="reference internal nav-link" href="#id277">
Aliases
</a>
</li>
@@ -4091,12 +4096,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id277">
+ <a class="reference internal nav-link" href="#id278">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id278">
+ <a class="reference internal nav-link" href="#id279">
Example
</a>
</li>
@@ -4112,12 +4117,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id279">
+ <a class="reference internal nav-link" href="#id280">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id280">
+ <a class="reference internal nav-link" href="#id281">
Example
</a>
</li>
@@ -4140,12 +4145,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id281">
+ <a class="reference internal nav-link" href="#id282">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id282">
+ <a class="reference internal nav-link" href="#id283">
Example
</a>
</li>
@@ -4161,12 +4166,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id283">
+ <a class="reference internal nav-link" href="#id284">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id284">
+ <a class="reference internal nav-link" href="#id285">
Example
</a>
</li>
@@ -4182,12 +4187,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id285">
+ <a class="reference internal nav-link" href="#id286">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id286">
+ <a class="reference internal nav-link" href="#id287">
Example
</a>
</li>
@@ -4203,12 +4208,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id287">
+ <a class="reference internal nav-link" href="#id288">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id288">
+ <a class="reference internal nav-link" href="#id289">
Example
</a>
</li>
@@ -4224,12 +4229,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id289">
+ <a class="reference internal nav-link" href="#id290">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id290">
+ <a class="reference internal nav-link" href="#id291">
Example
</a>
</li>
@@ -4245,12 +4250,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id291">
+ <a class="reference internal nav-link" href="#id292">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id292">
+ <a class="reference internal nav-link" href="#id293">
Example
</a>
</li>
@@ -4273,12 +4278,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id293">
+ <a class="reference internal nav-link" href="#id294">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id294">
+ <a class="reference internal nav-link" href="#id295">
Example
</a>
</li>
@@ -4294,12 +4299,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id295">
+ <a class="reference internal nav-link" href="#id296">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id296">
+ <a class="reference internal nav-link" href="#id297">
Example
</a>
</li>
@@ -4315,12 +4320,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id297">
+ <a class="reference internal nav-link" href="#id298">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id298">
+ <a class="reference internal nav-link" href="#id299">
Example
</a>
</li>
@@ -4336,7 +4341,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id299">
+ <a class="reference internal nav-link" href="#id300">
Example
</a>
</li>
@@ -6516,15 +6521,27 @@ Can be a constant, column, or function.</p></li>
<section id="from-unixtime">
<h3><code class="docutils literal notranslate"><span class="pre">from_unixtime</span></code><a class="headerlink" href="#from-unixtime" title="Link to this heading">¶</a></h3>
<p>Converts an integer to RFC3339 timestamp format (<code class="docutils literal notranslate"><span class="pre">YYYY-MM-DDT00:00:00.000000000Z</span></code>). Integers and unsigned integers are interpreted as nanoseconds since the unix epoch (<code class="docutils literal notranslate"><span class="pre">1970-01-01T00:00:00Z</span></code>) return the corresponding timestamp.</p>
-<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">from_unixtime</span><span class="p">(</span><span class="n">expression</span><span class="p">)</span>
+<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> <span class="n">timezone</span><span class="p">])</span>
</pre></div>
</div>
<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>
+<li><p><strong>expression</strong>: The expression to operate on. Can be a constant, column, or function, and any combination of operators.</p></li>
+<li><p><strong>timezone</strong>: Optional timezone to use when converting the integer to a timestamp. If not provided, the default timezone is UTC.</p></li>
</ul>
</section>
+<section id="id134">
+<h4>Example<a class="headerlink" href="#id134" 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">from_unixtime</span><span class="p">(</span><span class="mi">1599572549</span><span class="p">,</span><span class="w"> </span><span class="s1">'America/New_York'</span><span class="p">);</span>
+<span class="o">+</span><span class="c1">-----------------------------------------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span class="n">from_unixtime</span><span class="p">(</span><span class="n">Int64</span><span class="p">(</span><span class="mi">1599572549</span><span class="p">),</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"America/New_York"</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
+<span class="o">+</span><span class="c1">-----------------------------------------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">2020</span><span class="o">-</span><span class="mi">09</span><span class="o">-</span><span class="mi">08</span><span class="n">T09</span><span class="p">:</span><span class="mi">42</span><span class="p">:</span><span class="mi">29</span><span class="o">-</span><span class="mi">04</span><span class="p">:</span><span class="mi">00</span><span class="w"> </span><span class="o">|</span>
+<span class="o">+</span><span class="c1">-----------------------------------------------------------+</span>
+</pre></div>
+</div>
+</section>
</section>
<section id="make-date">
<h3><code class="docutils literal notranslate"><span class="pre">make_date</span></code><a class="headerlink" href="#make-date" title="Link to this heading">¶</a></h3>
@@ -6532,16 +6549,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="id134">
-<h4>Arguments<a class="headerlink" href="#id134" title="Link to this heading">¶</a></h4>
+<section id="id135">
+<h4>Arguments<a class="headerlink" href="#id135" 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="id135">
-<h4>Example<a class="headerlink" href="#id135" title="Link to this heading">¶</a></h4>
+<section id="id136">
+<h4>Example<a class="headerlink" href="#id136" 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>
@@ -6566,8 +6583,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="id136">
-<h4>Aliases<a class="headerlink" href="#id136" title="Link to this heading">¶</a></h4>
+<section id="id137">
+<h4>Aliases<a class="headerlink" href="#id137" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>current_timestamp</p></li>
</ul>
@@ -6579,16 +6596,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="id137">
-<h4>Arguments<a class="headerlink" href="#id137" title="Link to this heading">¶</a></h4>
+<section id="id138">
+<h4>Arguments<a class="headerlink" href="#id138" 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="id138">
-<h4>Example<a class="headerlink" href="#id138" title="Link to this heading">¶</a></h4>
+<section id="id139">
+<h4>Example<a class="headerlink" href="#id139" 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>
@@ -6599,8 +6616,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="id139">
-<h4>Aliases<a class="headerlink" href="#id139" title="Link to this heading">¶</a></h4>
+<section id="id140">
+<h4>Aliases<a class="headerlink" href="#id140" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>date_format</p></li>
</ul>
@@ -6617,8 +6634,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="id140">
-<h4>Arguments<a class="headerlink" href="#id140" title="Link to this heading">¶</a></h4>
+<section id="id141">
+<h4>Arguments<a class="headerlink" href="#id141" 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
@@ -6626,8 +6643,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="id141">
-<h4>Example<a class="headerlink" href="#id141" title="Link to this heading">¶</a></h4>
+<section id="id142">
+<h4>Example<a class="headerlink" href="#id142" 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>
@@ -6651,14 +6668,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="id142">
-<h4>Arguments<a class="headerlink" href="#id142" title="Link to this heading">¶</a></h4>
+<section id="id143">
+<h4>Arguments<a class="headerlink" href="#id143" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Time expression to operate on. Can be a constant, column, or function.</p></li>
</ul>
</section>
-<section id="id143">
-<h4>Example<a class="headerlink" href="#id143" title="Link to this heading">¶</a></h4>
+<section id="id144">
+<h4>Example<a class="headerlink" href="#id144" title="Link to this heading">¶</a></h4>
<div class="highlight-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>
@@ -6714,15 +6731,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="id144">
-<h4>Arguments<a class="headerlink" href="#id144" title="Link to this heading">¶</a></h4>
+<section id="id145">
+<h4>Arguments<a class="headerlink" href="#id145" 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="id145">
-<h4>Example<a class="headerlink" href="#id145" title="Link to this heading">¶</a></h4>
+<section id="id146">
+<h4>Example<a class="headerlink" href="#id146" title="Link to this heading">¶</a></h4>
<div class="highlight-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>
@@ -6746,15 +6763,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="id146">
-<h4>Arguments<a class="headerlink" href="#id146" title="Link to this heading">¶</a></h4>
+<section id="id147">
+<h4>Arguments<a class="headerlink" href="#id147" 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="id147">
-<h4>Example<a class="headerlink" href="#id147" title="Link to this heading">¶</a></h4>
+<section id="id148">
+<h4>Example<a class="headerlink" href="#id148" 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>
@@ -6778,15 +6795,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="id148">
-<h4>Arguments<a class="headerlink" href="#id148" title="Link to this heading">¶</a></h4>
+<section id="id149">
+<h4>Arguments<a class="headerlink" href="#id149" 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="id149">
-<h4>Example<a class="headerlink" href="#id149" title="Link to this heading">¶</a></h4>
+<section id="id150">
+<h4>Example<a class="headerlink" href="#id150" 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>
@@ -6810,15 +6827,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="id150">
-<h4>Arguments<a class="headerlink" href="#id150" title="Link to this heading">¶</a></h4>
+<section id="id151">
+<h4>Arguments<a class="headerlink" href="#id151" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>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="id151">
-<h4>Example<a class="headerlink" href="#id151" title="Link to this heading">¶</a></h4>
+<section id="id152">
+<h4>Example<a class="headerlink" href="#id152" title="Link to this heading">¶</a></h4>
<div class="highlight-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>
@@ -6842,15 +6859,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="id152">
-<h4>Arguments<a class="headerlink" href="#id152" title="Link to this heading">¶</a></h4>
+<section id="id153">
+<h4>Arguments<a class="headerlink" href="#id153" 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="id153">
-<h4>Example<a class="headerlink" href="#id153" title="Link to this heading">¶</a></h4>
+<section id="id154">
+<h4>Example<a class="headerlink" href="#id154" 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>
@@ -6874,15 +6891,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="id154">
-<h4>Arguments<a class="headerlink" href="#id154" title="Link to this heading">¶</a></h4>
+<section id="id155">
+<h4>Arguments<a class="headerlink" href="#id155" 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="id155">
-<h4>Example<a class="headerlink" href="#id155" title="Link to this heading">¶</a></h4>
+<section id="id156">
+<h4>Example<a class="headerlink" href="#id156" 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>
@@ -7003,15 +7020,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="id156">
-<h4>Arguments<a class="headerlink" href="#id156" title="Link to this heading">¶</a></h4>
+<section id="id157">
+<h4>Arguments<a class="headerlink" href="#id157" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>index</strong>: Index to extract the element from the array.</p></li>
</ul>
</section>
-<section id="id157">
-<h4>Example<a class="headerlink" href="#id157" title="Link to this heading">¶</a></h4>
+<section id="id158">
+<h4>Example<a class="headerlink" href="#id158" title="Link to this heading">¶</a></h4>
<div class="highlight-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 [...]
@@ -7021,8 +7038,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id158">
-<h4>Aliases<a class="headerlink" href="#id158" title="Link to this heading">¶</a></h4>
+<section id="id159">
+<h4>Aliases<a class="headerlink" href="#id159" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_any_value</p></li>
</ul>
@@ -7034,15 +7051,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="id159">
-<h4>Arguments<a class="headerlink" href="#id159" title="Link to this heading">¶</a></h4>
+<section id="id160">
+<h4>Arguments<a class="headerlink" href="#id160" 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="id160">
-<h4>Example<a class="headerlink" href="#id160" title="Link to this heading">¶</a></h4>
+<section id="id161">
+<h4>Example<a class="headerlink" href="#id161" 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>
@@ -7052,8 +7069,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id161">
-<h4>Aliases<a class="headerlink" href="#id161" title="Link to this heading">¶</a></h4>
+<section id="id162">
+<h4>Aliases<a class="headerlink" href="#id162" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_append</p></li>
<li><p>array_push_back</p></li>
@@ -7071,15 +7088,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="id162">
-<h4>Arguments<a class="headerlink" href="#id162" title="Link to this heading">¶</a></h4>
+<section id="id163">
+<h4>Arguments<a class="headerlink" href="#id163" 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="id163">
-<h4>Example<a class="headerlink" href="#id163" title="Link to this heading">¶</a></h4>
+<section id="id164">
+<h4>Example<a class="headerlink" href="#id164" 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>
@@ -7089,8 +7106,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id164">
-<h4>Aliases<a class="headerlink" href="#id164" title="Link to this heading">¶</a></h4>
+<section id="id165">
+<h4>Aliases<a class="headerlink" href="#id165" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>array_cat</p></li>
<li><p>list_concat</p></li>
@@ -7108,14 +7125,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="id165">
-<h4>Arguments<a class="headerlink" href="#id165" title="Link to this heading">¶</a></h4>
+<section id="id166">
+<h4>Arguments<a class="headerlink" href="#id166" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
</ul>
</section>
-<section id="id166">
-<h4>Example<a class="headerlink" href="#id166" title="Link to this heading">¶</a></h4>
+<section id="id167">
+<h4>Example<a class="headerlink" href="#id167" 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" [...]
@@ -7125,8 +7142,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id167">
-<h4>Aliases<a class="headerlink" href="#id167" title="Link to this heading">¶</a></h4>
+<section id="id168">
+<h4>Aliases<a class="headerlink" href="#id168" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_dims</p></li>
</ul>
@@ -7138,15 +7155,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="id168">
-<h4>Arguments<a class="headerlink" href="#id168" title="Link to this heading">¶</a></h4>
+<section id="id169">
+<h4>Arguments<a class="headerlink" href="#id169" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>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="id169">
-<h4>Example<a class="headerlink" href="#id169" title="Link to this heading">¶</a></h4>
+<section id="id170">
+<h4>Example<a class="headerlink" href="#id170" 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>
@@ -7156,8 +7173,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id170">
-<h4>Aliases<a class="headerlink" href="#id170" title="Link to this heading">¶</a></h4>
+<section id="id171">
+<h4>Aliases<a class="headerlink" href="#id171" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_distance</p></li>
</ul>
@@ -7169,14 +7186,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="id171">
-<h4>Arguments<a class="headerlink" href="#id171" title="Link to this heading">¶</a></h4>
+<section id="id172">
+<h4>Arguments<a class="headerlink" href="#id172" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or function, and any combination of array operators.</p></li>
</ul>
</section>
-<section id="id172">
-<h4>Example<a class="headerlink" href="#id172" title="Link to this heading">¶</a></h4>
+<section id="id173">
+<h4>Example<a class="headerlink" href="#id173" 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>
@@ -7186,8 +7203,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id173">
-<h4>Aliases<a class="headerlink" href="#id173" title="Link to this heading">¶</a></h4>
+<section id="id174">
+<h4>Aliases<a class="headerlink" href="#id174" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_distinct</p></li>
</ul>
@@ -7199,15 +7216,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="id174">
-<h4>Arguments<a class="headerlink" href="#id174" title="Link to this heading">¶</a></h4>
+<section id="id175">
+<h4>Arguments<a class="headerlink" href="#id175" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>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="id175">
-<h4>Example<a class="headerlink" href="#id175" title="Link to this heading">¶</a></h4>
+<section id="id176">
+<h4>Example<a class="headerlink" href="#id176" title="Link to this heading">¶</a></h4>
<div class="highlight-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 [...]
@@ -7217,8 +7234,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id176">
-<h4>Aliases<a class="headerlink" href="#id176" title="Link to this heading">¶</a></h4>
+<section id="id177">
+<h4>Aliases<a class="headerlink" href="#id177" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>array_extract</p></li>
<li><p>list_element</p></li>
@@ -7236,15 +7253,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="id177">
-<h4>Arguments<a class="headerlink" href="#id177" title="Link to this heading">¶</a></h4>
+<section id="id178">
+<h4>Arguments<a class="headerlink" href="#id178" 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="id178">
-<h4>Example<a class="headerlink" href="#id178" title="Link to this heading">¶</a></h4>
+<section id="id179">
+<h4>Example<a class="headerlink" href="#id179" 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"> < [...]
@@ -7260,8 +7277,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id179">
-<h4>Aliases<a class="headerlink" href="#id179" title="Link to this heading">¶</a></h4>
+<section id="id180">
+<h4>Aliases<a class="headerlink" href="#id180" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_except</p></li>
</ul>
@@ -7277,15 +7294,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="id180">
-<h4>Arguments<a class="headerlink" href="#id180" title="Link to this heading">¶</a></h4>
+<section id="id181">
+<h4>Arguments<a class="headerlink" href="#id181" 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="id181">
-<h4>Example<a class="headerlink" href="#id181" title="Link to this heading">¶</a></h4>
+<section id="id182">
+<h4>Example<a class="headerlink" href="#id182" 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>
@@ -7295,8 +7312,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id182">
-<h4>Aliases<a class="headerlink" href="#id182" title="Link to this heading">¶</a></h4>
+<section id="id183">
+<h4>Aliases<a class="headerlink" href="#id183" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_has</p></li>
<li><p>array_contains</p></li>
@@ -7310,15 +7327,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="id183">
-<h4>Arguments<a class="headerlink" href="#id183" title="Link to this heading">¶</a></h4>
+<section id="id184">
+<h4>Arguments<a class="headerlink" href="#id184" 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="id184">
-<h4>Example<a class="headerlink" href="#id184" title="Link to this heading">¶</a></h4>
+<section id="id185">
+<h4>Example<a class="headerlink" href="#id185" 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>
@@ -7328,8 +7345,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id185">
-<h4>Aliases<a class="headerlink" href="#id185" title="Link to this heading">¶</a></h4>
+<section id="id186">
+<h4>Aliases<a class="headerlink" href="#id186" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_has_all</p></li>
</ul>
@@ -7341,15 +7358,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="id186">
-<h4>Arguments<a class="headerlink" href="#id186" title="Link to this heading">¶</a></h4>
+<section id="id187">
+<h4>Arguments<a class="headerlink" href="#id187" 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="id187">
-<h4>Example<a class="headerlink" href="#id187" title="Link to this heading">¶</a></h4>
+<section id="id188">
+<h4>Example<a class="headerlink" href="#id188" 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>
@@ -7359,8 +7376,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id188">
-<h4>Aliases<a class="headerlink" href="#id188" title="Link to this heading">¶</a></h4>
+<section id="id189">
+<h4>Aliases<a class="headerlink" href="#id189" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_has_any</p></li>
</ul>
@@ -7376,14 +7393,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="id189">
-<h4>Arguments<a class="headerlink" href="#id189" title="Link to this heading">¶</a></h4>
+<section id="id190">
+<h4>Arguments<a class="headerlink" href="#id190" 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="id190">
-<h4>Example<a class="headerlink" href="#id190" title="Link to this heading">¶</a></h4>
+<section id="id191">
+<h4>Example<a class="headerlink" href="#id191" 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>
@@ -7393,8 +7410,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id191">
-<h4>Aliases<a class="headerlink" href="#id191" title="Link to this heading">¶</a></h4>
+<section id="id192">
+<h4>Aliases<a class="headerlink" href="#id192" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_intersect</p></li>
</ul>
@@ -7410,15 +7427,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="id192">
-<h4>Arguments<a class="headerlink" href="#id192" title="Link to this heading">¶</a></h4>
+<section id="id193">
+<h4>Arguments<a class="headerlink" href="#id193" 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="id193">
-<h4>Example<a class="headerlink" href="#id193" title="Link to this heading">¶</a></h4>
+<section id="id194">
+<h4>Example<a class="headerlink" href="#id194" 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=" [...]
@@ -7428,8 +7445,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id194">
-<h4>Aliases<a class="headerlink" href="#id194" title="Link to this heading">¶</a></h4>
+<section id="id195">
+<h4>Aliases<a class="headerlink" href="#id195" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_length</p></li>
</ul>
@@ -7441,14 +7458,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="id195">
-<h4>Arguments<a class="headerlink" href="#id195" title="Link to this heading">¶</a></h4>
+<section id="id196">
+<h4>Arguments<a class="headerlink" href="#id196" 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="id196">
-<h4>Example<a class="headerlink" href="#id196" title="Link to this heading">¶</a></h4>
+<section id="id197">
+<h4>Example<a class="headerlink" href="#id197" 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" [...]
@@ -7458,8 +7475,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id197">
-<h4>Aliases<a class="headerlink" href="#id197" title="Link to this heading">¶</a></h4>
+<section id="id198">
+<h4>Aliases<a class="headerlink" href="#id198" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_ndims</p></li>
</ul>
@@ -7471,15 +7488,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="id198">
-<h4>Arguments<a class="headerlink" href="#id198" title="Link to this heading">¶</a></h4>
+<section id="id199">
+<h4>Arguments<a class="headerlink" href="#id199" 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="id199">
-<h4>Example<a class="headerlink" href="#id199" title="Link to this heading">¶</a></h4>
+<section id="id200">
+<h4>Example<a class="headerlink" href="#id200" 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 [...]
@@ -7489,8 +7506,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id200">
-<h4>Aliases<a class="headerlink" href="#id200" title="Link to this heading">¶</a></h4>
+<section id="id201">
+<h4>Aliases<a class="headerlink" href="#id201" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_pop_back</p></li>
</ul>
@@ -7502,15 +7519,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="id201">
-<h4>Arguments<a class="headerlink" href="#id201" title="Link to this heading">¶</a></h4>
+<section id="id202">
+<h4>Arguments<a class="headerlink" href="#id202" 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="id202">
-<h4>Example<a class="headerlink" href="#id202" title="Link to this heading">¶</a></h4>
+<section id="id203">
+<h4>Example<a class="headerlink" href="#id203" 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 [...]
@@ -7520,8 +7537,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id203">
-<h4>Aliases<a class="headerlink" href="#id203" title="Link to this heading">¶</a></h4>
+<section id="id204">
+<h4>Aliases<a class="headerlink" href="#id204" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_pop_front</p></li>
</ul>
@@ -7534,16 +7551,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="id204">
-<h4>Arguments<a class="headerlink" href="#id204" title="Link to this heading">¶</a></h4>
+<section id="id205">
+<h4>Arguments<a class="headerlink" href="#id205" 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="id205">
-<h4>Example<a class="headerlink" href="#id205" title="Link to this heading">¶</a></h4>
+<section id="id206">
+<h4>Example<a class="headerlink" href="#id206" 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 [...]
@@ -7559,8 +7576,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id206">
-<h4>Aliases<a class="headerlink" href="#id206" title="Link to this heading">¶</a></h4>
+<section id="id207">
+<h4>Aliases<a class="headerlink" href="#id207" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_position</p></li>
<li><p>array_indexof</p></li>
@@ -7575,16 +7592,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="id207">
-<h4>Arguments<a class="headerlink" href="#id207" title="Link to this heading">¶</a></h4>
+<section id="id208">
+<h4>Arguments<a class="headerlink" href="#id208" 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="id208">
-<h4>Example<a class="headerlink" href="#id208" title="Link to this heading">¶</a></h4>
+<section id="id209">
+<h4>Example<a class="headerlink" href="#id209" 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 [...]
@@ -7600,8 +7617,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id209">
-<h4>Aliases<a class="headerlink" href="#id209" title="Link to this heading">¶</a></h4>
+<section id="id210">
+<h4>Aliases<a class="headerlink" href="#id210" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_positions</p></li>
</ul>
@@ -7613,15 +7630,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="id210">
-<h4>Arguments<a class="headerlink" href="#id210" title="Link to this heading">¶</a></h4>
+<section id="id211">
+<h4>Arguments<a class="headerlink" href="#id211" 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="id211">
-<h4>Example<a class="headerlink" href="#id211" title="Link to this heading">¶</a></h4>
+<section id="id212">
+<h4>Example<a class="headerlink" href="#id212" 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>
@@ -7631,8 +7648,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id212">
-<h4>Aliases<a class="headerlink" href="#id212" title="Link to this heading">¶</a></h4>
+<section id="id213">
+<h4>Aliases<a class="headerlink" href="#id213" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_prepend</p></li>
<li><p>array_push_front</p></li>
@@ -7654,15 +7671,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="id213">
-<h4>Arguments<a class="headerlink" href="#id213" title="Link to this heading">¶</a></h4>
+<section id="id214">
+<h4>Arguments<a class="headerlink" href="#id214" 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="id214">
-<h4>Example<a class="headerlink" href="#id214" title="Link to this heading">¶</a></h4>
+<section id="id215">
+<h4>Example<a class="headerlink" href="#id215" 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 [...]
@@ -7672,8 +7689,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id215">
-<h4>Aliases<a class="headerlink" href="#id215" title="Link to this heading">¶</a></h4>
+<section id="id216">
+<h4>Aliases<a class="headerlink" href="#id216" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_remove</p></li>
</ul>
@@ -7685,15 +7702,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="id216">
-<h4>Arguments<a class="headerlink" href="#id216" title="Link to this heading">¶</a></h4>
+<section id="id217">
+<h4>Arguments<a class="headerlink" href="#id217" 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="id217">
-<h4>Example<a class="headerlink" href="#id217" title="Link to this heading">¶</a></h4>
+<section id="id218">
+<h4>Example<a class="headerlink" href="#id218" 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 [...]
@@ -7703,8 +7720,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id218">
-<h4>Aliases<a class="headerlink" href="#id218" title="Link to this heading">¶</a></h4>
+<section id="id219">
+<h4>Aliases<a class="headerlink" href="#id219" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_remove_all</p></li>
</ul>
@@ -7716,15 +7733,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="id219">
-<h4>Arguments<a class="headerlink" href="#id219" title="Link to this heading">¶</a></h4>
+<section id="id220">
+<h4>Arguments<a class="headerlink" href="#id220" 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="id220">
-<h4>Example<a class="headerlink" href="#id220" title="Link to this heading">¶</a></h4>
+<section id="id221">
+<h4>Example<a class="headerlink" href="#id221" 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 [...]
@@ -7734,8 +7751,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id221">
-<h4>Aliases<a class="headerlink" href="#id221" title="Link to this heading">¶</a></h4>
+<section id="id222">
+<h4>Aliases<a class="headerlink" href="#id222" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_remove_n</p></li>
</ul>
@@ -7747,15 +7764,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="id222">
-<h4>Arguments<a class="headerlink" href="#id222" title="Link to this heading">¶</a></h4>
+<section id="id223">
+<h4>Arguments<a class="headerlink" href="#id223" 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="id223">
-<h4>Example<a class="headerlink" href="#id223" title="Link to this heading">¶</a></h4>
+<section id="id224">
+<h4>Example<a class="headerlink" href="#id224" 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>
@@ -7771,8 +7788,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id224">
-<h4>Aliases<a class="headerlink" href="#id224" title="Link to this heading">¶</a></h4>
+<section id="id225">
+<h4>Aliases<a class="headerlink" href="#id225" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_repeat</p></li>
</ul>
@@ -7784,8 +7801,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="id225">
-<h4>Arguments<a class="headerlink" href="#id225" title="Link to this heading">¶</a></h4>
+<section id="id226">
+<h4>Arguments<a class="headerlink" href="#id226" 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>
@@ -7793,8 +7810,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="id226">
-<h4>Example<a class="headerlink" href="#id226" title="Link to this heading">¶</a></h4>
+<section id="id227">
+<h4>Example<a class="headerlink" href="#id227" 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 [...]
@@ -7804,8 +7821,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id227">
-<h4>Aliases<a class="headerlink" href="#id227" title="Link to this heading">¶</a></h4>
+<section id="id228">
+<h4>Aliases<a class="headerlink" href="#id228" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_replace</p></li>
</ul>
@@ -7817,8 +7834,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="id228">
-<h4>Arguments<a class="headerlink" href="#id228" title="Link to this heading">¶</a></h4>
+<section id="id229">
+<h4>Arguments<a class="headerlink" href="#id229" 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>
@@ -7826,8 +7843,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="id229">
-<h4>Example<a class="headerlink" href="#id229" title="Link to this heading">¶</a></h4>
+<section id="id230">
+<h4>Example<a class="headerlink" href="#id230" 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 [...]
@@ -7837,8 +7854,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id230">
-<h4>Aliases<a class="headerlink" href="#id230" title="Link to this heading">¶</a></h4>
+<section id="id231">
+<h4>Aliases<a class="headerlink" href="#id231" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_replace_all</p></li>
</ul>
@@ -7850,8 +7867,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="id231">
-<h4>Arguments<a class="headerlink" href="#id231" title="Link to this heading">¶</a></h4>
+<section id="id232">
+<h4>Arguments<a class="headerlink" href="#id232" 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>
@@ -7859,8 +7876,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="id232">
-<h4>Example<a class="headerlink" href="#id232" title="Link to this heading">¶</a></h4>
+<section id="id233">
+<h4>Example<a class="headerlink" href="#id233" 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 [...]
@@ -7870,8 +7887,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id233">
-<h4>Aliases<a class="headerlink" href="#id233" title="Link to this heading">¶</a></h4>
+<section id="id234">
+<h4>Aliases<a class="headerlink" href="#id234" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_replace_n</p></li>
</ul>
@@ -7883,16 +7900,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="id234">
-<h4>Arguments<a class="headerlink" href="#id234" title="Link to this heading">¶</a></h4>
+<section id="id235">
+<h4>Arguments<a class="headerlink" href="#id235" 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="id235">
-<h4>Example<a class="headerlink" href="#id235" title="Link to this heading">¶</a></h4>
+<section id="id236">
+<h4>Example<a class="headerlink" href="#id236" 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>
@@ -7902,8 +7919,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id236">
-<h4>Aliases<a class="headerlink" href="#id236" title="Link to this heading">¶</a></h4>
+<section id="id237">
+<h4>Aliases<a class="headerlink" href="#id237" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_resize</p></li>
</ul>
@@ -7915,14 +7932,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="id237">
-<h4>Arguments<a class="headerlink" href="#id237" title="Link to this heading">¶</a></h4>
+<section id="id238">
+<h4>Arguments<a class="headerlink" href="#id238" 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="id238">
-<h4>Example<a class="headerlink" href="#id238" title="Link to this heading">¶</a></h4>
+<section id="id239">
+<h4>Example<a class="headerlink" href="#id239" 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=" [...]
@@ -7932,8 +7949,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id239">
-<h4>Aliases<a class="headerlink" href="#id239" title="Link to this heading">¶</a></h4>
+<section id="id240">
+<h4>Aliases<a class="headerlink" href="#id240" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_reverse</p></li>
</ul>
@@ -7945,15 +7962,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="id240">
-<h4>Arguments<a class="headerlink" href="#id240" title="Link to this heading">¶</a></h4>
+<section id="id241">
+<h4>Arguments<a class="headerlink" href="#id241" 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="id241">
-<h4>Example<a class="headerlink" href="#id241" title="Link to this heading">¶</a></h4>
+<section id="id242">
+<h4>Example<a class="headerlink" href="#id242" 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 [...]
@@ -7963,8 +7980,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id242">
-<h4>Aliases<a class="headerlink" href="#id242" title="Link to this heading">¶</a></h4>
+<section id="id243">
+<h4>Aliases<a class="headerlink" href="#id243" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_slice</p></li>
</ul>
@@ -7976,16 +7993,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="id243">
-<h4>Arguments<a class="headerlink" href="#id243" title="Link to this heading">¶</a></h4>
+<section id="id244">
+<h4>Arguments<a class="headerlink" href="#id244" 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="id244">
-<h4>Example<a class="headerlink" href="#id244" title="Link to this heading">¶</a></h4>
+<section id="id245">
+<h4>Example<a class="headerlink" href="#id245" 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>
@@ -7995,8 +8012,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id245">
-<h4>Aliases<a class="headerlink" href="#id245" title="Link to this heading">¶</a></h4>
+<section id="id246">
+<h4>Aliases<a class="headerlink" href="#id246" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_sort</p></li>
</ul>
@@ -8008,15 +8025,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="id246">
-<h4>Arguments<a class="headerlink" href="#id246" title="Link to this heading">¶</a></h4>
+<section id="id247">
+<h4>Arguments<a class="headerlink" href="#id247" 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="id247">
-<h4>Example<a class="headerlink" href="#id247" title="Link to this heading">¶</a></h4>
+<section id="id248">
+<h4>Example<a class="headerlink" href="#id248" 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 [...]
@@ -8026,8 +8043,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id248">
-<h4>Aliases<a class="headerlink" href="#id248" title="Link to this heading">¶</a></h4>
+<section id="id249">
+<h4>Aliases<a class="headerlink" href="#id249" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_to_string</p></li>
<li><p>array_join</p></li>
@@ -8041,14 +8058,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="id249">
-<h4>Arguments<a class="headerlink" href="#id249" title="Link to this heading">¶</a></h4>
+<section id="id250">
+<h4>Arguments<a class="headerlink" href="#id250" 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="id251">
+<h4>Example<a class="headerlink" href="#id251" 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>
@@ -8058,8 +8075,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="id252">
+<h4>Aliases<a class="headerlink" href="#id252" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_union</p></li>
</ul>
@@ -8071,14 +8088,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="id252">
-<h4>Arguments<a class="headerlink" href="#id252" title="Link to this heading">¶</a></h4>
+<section id="id253">
+<h4>Arguments<a class="headerlink" href="#id253" 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="id254">
+<h4>Example<a class="headerlink" href="#id254" 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" [...]
@@ -8095,14 +8112,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="id254">
-<h4>Arguments<a class="headerlink" href="#id254" title="Link to this heading">¶</a></h4>
+<section id="id255">
+<h4>Arguments<a class="headerlink" href="#id255" 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="id255">
-<h4>Example<a class="headerlink" href="#id255" title="Link to this heading">¶</a></h4>
+<section id="id256">
+<h4>Example<a class="headerlink" href="#id256" 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>
@@ -8112,8 +8129,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id256">
-<h4>Aliases<a class="headerlink" href="#id256" title="Link to this heading">¶</a></h4>
+<section id="id257">
+<h4>Aliases<a class="headerlink" href="#id257" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>array_empty</p></li>
<li><p>list_empty</p></li>
@@ -8131,14 +8148,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="id257">
-<h4>Arguments<a class="headerlink" href="#id257" title="Link to this heading">¶</a></h4>
+<section id="id258">
+<h4>Arguments<a class="headerlink" href="#id258" 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="id258">
-<h4>Example<a class="headerlink" href="#id258" title="Link to this heading">¶</a></h4>
+<section id="id259">
+<h4>Example<a class="headerlink" href="#id259" 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>
@@ -8155,16 +8172,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="id259">
-<h4>Arguments<a class="headerlink" href="#id259" title="Link to this heading">¶</a></h4>
+<section id="id260">
+<h4>Arguments<a class="headerlink" href="#id260" 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="id260">
-<h4>Example<a class="headerlink" href="#id260" title="Link to this heading">¶</a></h4>
+<section id="id261">
+<h4>Example<a class="headerlink" href="#id261" 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>
@@ -8341,14 +8358,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="id261">
-<h4>Arguments<a class="headerlink" href="#id261" title="Link to this heading">¶</a></h4>
+<section id="id262">
+<h4>Arguments<a class="headerlink" href="#id262" 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="id262">
-<h4>Example<a class="headerlink" href="#id262" title="Link to this heading">¶</a></h4>
+<section id="id263">
+<h4>Example<a class="headerlink" href="#id263" 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 [...]
@@ -8358,8 +8375,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="id264">
+<h4>Aliases<a class="headerlink" href="#id264" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>make_list</p></li>
</ul>
@@ -8375,16 +8392,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="id264">
-<h4>Arguments<a class="headerlink" href="#id264" title="Link to this heading">¶</a></h4>
+<section id="id265">
+<h4>Arguments<a class="headerlink" href="#id265" 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="id265">
-<h4>Example<a class="headerlink" href="#id265" title="Link to this heading">¶</a></h4>
+<section id="id266">
+<h4>Example<a class="headerlink" href="#id266" 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>
@@ -8408,15 +8425,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="id266">
-<h4>Arguments<a class="headerlink" href="#id266" title="Link to this heading">¶</a></h4>
+<section id="id267">
+<h4>Arguments<a class="headerlink" href="#id267" 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="id267">
-<h4>Example<a class="headerlink" href="#id267" title="Link to this heading">¶</a></h4>
+<section id="id268">
+<h4>Example<a class="headerlink" href="#id268" 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 [...]
@@ -8426,8 +8443,8 @@ an error will be returned.</p></li>
</pre></div>
</div>
</section>
-<section id="id268">
-<h4>Aliases<a class="headerlink" href="#id268" title="Link to this heading">¶</a></h4>
+<section id="id269">
+<h4>Aliases<a class="headerlink" href="#id269" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>string_to_list</p></li>
</ul>
@@ -8451,15 +8468,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="id269">
-<h4>Arguments<a class="headerlink" href="#id269" title="Link to this heading">¶</a></h4>
+<section id="id270">
+<h4>Arguments<a class="headerlink" href="#id270" 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="id270">
-<h4>Example<a class="headerlink" href="#id270" title="Link to this heading">¶</a></h4>
+<section id="id271">
+<h4>Example<a class="headerlink" href="#id271" 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>
@@ -8492,14 +8509,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="id271">
-<h4>Arguments<a class="headerlink" href="#id271" title="Link to this heading">¶</a></h4>
+<section id="id272">
+<h4>Arguments<a class="headerlink" href="#id272" 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="id272">
-<h4>Example<a class="headerlink" href="#id272" title="Link to this heading">¶</a></h4>
+<section id="id273">
+<h4>Example<a class="headerlink" href="#id273" 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>
@@ -8530,8 +8547,8 @@ a struct type of fields <code class="docutils literal notranslate"><span class="
</pre></div>
</div>
</section>
-<section id="id273">
-<h4>Aliases<a class="headerlink" href="#id273" title="Link to this heading">¶</a></h4>
+<section id="id274">
+<h4>Aliases<a class="headerlink" href="#id274" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>row</p></li>
</ul>
@@ -8560,8 +8577,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="id274">
-<h4>Arguments<a class="headerlink" href="#id274" title="Link to this heading">¶</a></h4>
+<section id="id275">
+<h4>Arguments<a class="headerlink" href="#id275" 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>
@@ -8569,8 +8586,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="id275">
-<h4>Example<a class="headerlink" href="#id275" title="Link to this heading">¶</a></h4>
+<section id="id276">
+<h4>Example<a class="headerlink" href="#id276" 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>
@@ -8627,8 +8644,8 @@ SELECT map_extract(MAP {'x': 10, 'y': NULL, 'z': 30}, &#
</pre></div>
</div>
</section>
-<section id="id276">
-<h4>Aliases<a class="headerlink" href="#id276" title="Link to this heading">¶</a></h4>
+<section id="id277">
+<h4>Aliases<a class="headerlink" href="#id277" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>element_at</p></li>
</ul>
@@ -8640,14 +8657,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="id277">
-<h4>Arguments<a class="headerlink" href="#id277" title="Link to this heading">¶</a></h4>
+<section id="id278">
+<h4>Arguments<a class="headerlink" href="#id278" 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="id278">
-<h4>Example<a class="headerlink" href="#id278" title="Link to this heading">¶</a></h4>
+<section id="id279">
+<h4>Example<a class="headerlink" href="#id279" 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>
@@ -8665,14 +8682,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="id279">
-<h4>Arguments<a class="headerlink" href="#id279" title="Link to this heading">¶</a></h4>
+<section id="id280">
+<h4>Arguments<a class="headerlink" href="#id280" 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="id280">
-<h4>Example<a class="headerlink" href="#id280" title="Link to this heading">¶</a></h4>
+<section id="id281">
+<h4>Example<a class="headerlink" href="#id281" 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>
@@ -8701,8 +8718,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="id281">
-<h4>Arguments<a class="headerlink" href="#id281" title="Link to this heading">¶</a></h4>
+<section id="id282">
+<h4>Arguments<a class="headerlink" href="#id282" 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>
@@ -8716,8 +8733,8 @@ SELECT map_extract(MAP {'x': 10, 'y': NULL, 'z': 30}, &#
<li><p>blake3</p></li>
</ul>
</section>
-<section id="id282">
-<h4>Example<a class="headerlink" href="#id282" title="Link to this heading">¶</a></h4>
+<section id="id283">
+<h4>Example<a class="headerlink" href="#id283" 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>
@@ -8734,14 +8751,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="id283">
-<h4>Arguments<a class="headerlink" href="#id283" title="Link to this heading">¶</a></h4>
+<section id="id284">
+<h4>Arguments<a class="headerlink" href="#id284" 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="id284">
-<h4>Example<a class="headerlink" href="#id284" title="Link to this heading">¶</a></h4>
+<section id="id285">
+<h4>Example<a class="headerlink" href="#id285" 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>
@@ -8758,14 +8775,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="id285">
-<h4>Arguments<a class="headerlink" href="#id285" title="Link to this heading">¶</a></h4>
+<section id="id286">
+<h4>Arguments<a class="headerlink" href="#id286" 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="id286">
-<h4>Example<a class="headerlink" href="#id286" title="Link to this heading">¶</a></h4>
+<section id="id287">
+<h4>Example<a class="headerlink" href="#id287" 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>
@@ -8782,14 +8799,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="id287">
-<h4>Arguments<a class="headerlink" href="#id287" title="Link to this heading">¶</a></h4>
+<section id="id288">
+<h4>Arguments<a class="headerlink" href="#id288" 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="id288">
-<h4>Example<a class="headerlink" href="#id288" title="Link to this heading">¶</a></h4>
+<section id="id289">
+<h4>Example<a class="headerlink" href="#id289" 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>
@@ -8806,14 +8823,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="id289">
-<h4>Arguments<a class="headerlink" href="#id289" title="Link to this heading">¶</a></h4>
+<section id="id290">
+<h4>Arguments<a class="headerlink" href="#id290" 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="id290">
-<h4>Example<a class="headerlink" href="#id290" title="Link to this heading">¶</a></h4>
+<section id="id291">
+<h4>Example<a class="headerlink" href="#id291" 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>
@@ -8830,14 +8847,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="id291">
-<h4>Arguments<a class="headerlink" href="#id291" title="Link to this heading">¶</a></h4>
+<section id="id292">
+<h4>Arguments<a class="headerlink" href="#id292" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String</p></li>
</ul>
</section>
-<section id="id292">
-<h4>Example<a class="headerlink" href="#id292" title="Link to this heading">¶</a></h4>
+<section id="id293">
+<h4>Example<a class="headerlink" href="#id293" 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>
@@ -8863,15 +8880,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="id293">
-<h4>Arguments<a class="headerlink" href="#id293" title="Link to this heading">¶</a></h4>
+<section id="id294">
+<h4>Arguments<a class="headerlink" href="#id294" 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="id294">
-<h4>Example<a class="headerlink" href="#id294" title="Link to this heading">¶</a></h4>
+<section id="id295">
+<h4>Example<a class="headerlink" href="#id295" 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>
@@ -8892,14 +8909,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="id295">
-<h4>Arguments<a class="headerlink" href="#id295" title="Link to this heading">¶</a></h4>
+<section id="id296">
+<h4>Arguments<a class="headerlink" href="#id296" 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="id296">
-<h4>Example<a class="headerlink" href="#id296" title="Link to this heading">¶</a></h4>
+<section id="id297">
+<h4>Example<a class="headerlink" href="#id297" 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=" [...]
@@ -8919,15 +8936,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="id297">
-<h4>Arguments<a class="headerlink" href="#id297" title="Link to this heading">¶</a></h4>
+<section id="id298">
+<h4>Arguments<a class="headerlink" href="#id298" 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="id298">
-<h4>Example<a class="headerlink" href="#id298" 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">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>
@@ -8960,8 +8977,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="id299">
-<h4>Example<a class="headerlink" href="#id299" title="Link to this heading">¶</a></h4>
+<section id="id300">
+<h4>Example<a class="headerlink" href="#id300" 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