(datafusion) branch asf-site updated: Publish built docs triggered by f9ef488aecca9a445a5110079fb2f295c80a8850

github-bot Wed, 22 May 2024 10:50:54 -0700

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 1f6867e97b Publish built docs triggered by 
f9ef488aecca9a445a5110079fb2f295c80a8850
1f6867e97b is described below

commit 1f6867e97bb1a48f46ce6221fdf588e20b272c37
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Wed May 22 17:50:42 2024 +0000

    Publish built docs triggered by f9ef488aecca9a445a5110079fb2f295c80a8850
---
 _sources/user-guide/sql/scalar_functions.md.txt |  36 ++
 searchindex.js                                  |   2 +-
 user-guide/sql/scalar_functions.html            | 760 +++++++++++++-----------
 3 files changed, 446 insertions(+), 352 deletions(-)

diff --git a/_sources/user-guide/sql/scalar_functions.md.txt 
b/_sources/user-guide/sql/scalar_functions.md.txt
index f0feb9ec21..625e0d95b5 100644
--- a/_sources/user-guide/sql/scalar_functions.md.txt
+++ b/_sources/user-guide/sql/scalar_functions.md.txt
@@ -1464,6 +1464,7 @@ position(substr in origstr)
 - [to_timestamp_seconds](#to_timestamp_seconds)
 - [to_timestamp_nanos](#to_timestamp_nanos)
 - [from_unixtime](#from_unixtime)
+- [to_unixtime](#to_unixtime)
 
 ### `now`
 
@@ -1964,6 +1965,41 @@ from_unixtime(expression)
 - **expression**: Expression to operate on.
   Can be a constant, column, or function, and any combination of arithmetic 
operators.
 
+### `to_unixtime`
+
+Converts a value to seconds since the unix epoch (`1970-01-01T00:00:00Z`).
+Supports strings, dates, timestamps and double types as input.
+Strings are parsed as RFC3339 (e.g. '2023-07-20T05:44:00') if no [Chrono 
formats] are provided.
+
+```
+to_unixtime(expression[, ..., format_n])
+```
+
+#### Arguments
+
+- **expression**: Expression to operate on.
+  Can be a constant, column, or function, and any combination of arithmetic 
operators.
+- **format_n**: Optional [Chrono format] 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.
+
+#### Example
+
+```
+> select to_unixtime('2020-09-08T12:00:00+00:00');
++------------------------------------------------+
+| to_unixtime(Utf8("2020-09-08T12:00:00+00:00")) |
++------------------------------------------------+
+| 1599566400                                     |
++------------------------------------------------+
+> select to_unixtime('01-14-2023 01:01:30+05:30', '%q', '%d-%m-%Y %H/%M/%S', 
'%+', '%m-%d-%Y %H:%M:%S%#z');
++-----------------------------------------------------------------------------------------------------------------------------+
+| to_unixtime(Utf8("01-14-2023 01:01:30+05:30"),Utf8("%q"),Utf8("%d-%m-%Y 
%H/%M/%S"),Utf8("%+"),Utf8("%m-%d-%Y %H:%M:%S%#z")) |
++-----------------------------------------------------------------------------------------------------------------------------+
+| 1673638290                                                                   
                                               |
++-----------------------------------------------------------------------------------------------------------------------------+
+```
+
 ## Array Functions
 
 - [array_append](#array_append)
diff --git a/searchindex.js b/searchindex.js
index c065f4efd1..ea2dd0a61d 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"alltitles": {"!=": [[42, "op-neq"]], "!~": [[42, 
"op-re-not-match"]], "!~*": [[42, "op-re-not-match-i"]], "!~~": [[42, "id18"]], 
"!~~*": [[42, "id19"]], "#": [[42, "op-bit-xor"]], "%": [[42, "op-modulo"]], 
"&": [[42, "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"]], "*": 
[[42, "op-multiply"]], "+": [[42, "op-plus"]], "-": [[42, "op-minus"]], "/": 
[[4 [...]
\ No newline at end of file
+Search.setIndex({"alltitles": {"!=": [[42, "op-neq"]], "!~": [[42, 
"op-re-not-match"]], "!~*": [[42, "op-re-not-match-i"]], "!~~": [[42, "id18"]], 
"!~~*": [[42, "id19"]], "#": [[42, "op-bit-xor"]], "%": [[42, "op-modulo"]], 
"&": [[42, "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"]], "*": 
[[42, "op-multiply"]], "+": [[42, "op-plus"]], "-": [[42, "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 78b2dfdfbd..d133a596b2 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -2150,6 +2150,27 @@
      </li>
     </ul>
    </li>
+   <li class="toc-h3 nav-item toc-entry">
+    <a class="reference internal nav-link" href="#to-unixtime">
+     <code class="docutils literal notranslate">
+      <span class="pre">
+       to_unixtime
+      </span>
+     </code>
+    </a>
+    <ul class="nav section-nav flex-column">
+     <li class="toc-h4 nav-item toc-entry">
+      <a class="reference internal nav-link" href="#id105">
+       Arguments
+      </a>
+     </li>
+     <li class="toc-h4 nav-item toc-entry">
+      <a class="reference internal nav-link" href="#id106">
+       Example
+      </a>
+     </li>
+    </ul>
+   </li>
   </ul>
  </li>
  <li class="toc-h2 nav-item toc-entry">
@@ -2167,17 +2188,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id105">
+      <a class="reference internal nav-link" href="#id107">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id106">
+      <a class="reference internal nav-link" href="#id108">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id107">
+      <a class="reference internal nav-link" href="#id109">
        Aliases
       </a>
      </li>
@@ -2193,17 +2214,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id108">
+      <a class="reference internal nav-link" href="#id110">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id109">
+      <a class="reference internal nav-link" href="#id111">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id110">
+      <a class="reference internal nav-link" href="#id112">
        Aliases
       </a>
      </li>
@@ -2219,17 +2240,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id111">
+      <a class="reference internal nav-link" href="#id113">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id112">
+      <a class="reference internal nav-link" href="#id114">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id113">
+      <a class="reference internal nav-link" href="#id115">
        Aliases
       </a>
      </li>
@@ -2254,17 +2275,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id114">
+      <a class="reference internal nav-link" href="#id116">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id115">
+      <a class="reference internal nav-link" href="#id117">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id116">
+      <a class="reference internal nav-link" href="#id118">
        Aliases
       </a>
      </li>
@@ -2289,12 +2310,12 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id117">
+      <a class="reference internal nav-link" href="#id119">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id118">
+      <a class="reference internal nav-link" href="#id120">
        Aliases
       </a>
      </li>
@@ -2310,12 +2331,12 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id119">
+      <a class="reference internal nav-link" href="#id121">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id120">
+      <a class="reference internal nav-link" href="#id122">
        Aliases
       </a>
      </li>
@@ -2331,12 +2352,12 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id121">
+      <a class="reference internal nav-link" href="#id123">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id122">
+      <a class="reference internal nav-link" href="#id124">
        Aliases
       </a>
      </li>
@@ -2352,17 +2373,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id123">
+      <a class="reference internal nav-link" href="#id125">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id124">
+      <a class="reference internal nav-link" href="#id126">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id125">
+      <a class="reference internal nav-link" href="#id127">
        Aliases
       </a>
      </li>
@@ -2378,17 +2399,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id126">
+      <a class="reference internal nav-link" href="#id128">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id127">
+      <a class="reference internal nav-link" href="#id129">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id128">
+      <a class="reference internal nav-link" href="#id130">
        Aliases
       </a>
      </li>
@@ -2404,17 +2425,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id129">
+      <a class="reference internal nav-link" href="#id131">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id130">
+      <a class="reference internal nav-link" href="#id132">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id131">
+      <a class="reference internal nav-link" href="#id133">
        Aliases
       </a>
      </li>
@@ -2439,7 +2460,7 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id132">
+      <a class="reference internal nav-link" href="#id134">
        Arguments
       </a>
      </li>
@@ -2455,7 +2476,7 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id133">
+      <a class="reference internal nav-link" href="#id135">
        Arguments
       </a>
      </li>
@@ -2480,17 +2501,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id134">
+      <a class="reference internal nav-link" href="#id136">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id135">
+      <a class="reference internal nav-link" href="#id137">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id136">
+      <a class="reference internal nav-link" href="#id138">
        Aliases
       </a>
      </li>
@@ -2515,17 +2536,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="#id139">
        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="#id140">
        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="#id141">
        Aliases
       </a>
      </li>
@@ -2541,17 +2562,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id140">
+      <a class="reference internal nav-link" href="#id142">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id141">
+      <a class="reference internal nav-link" href="#id143">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id142">
+      <a class="reference internal nav-link" href="#id144">
        Aliases
       </a>
      </li>
@@ -2567,17 +2588,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id143">
+      <a class="reference internal nav-link" href="#id145">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id144">
+      <a class="reference internal nav-link" href="#id146">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id145">
+      <a class="reference internal nav-link" href="#id147">
        Aliases
       </a>
      </li>
@@ -2593,17 +2614,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id146">
+      <a class="reference internal nav-link" href="#id148">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id147">
+      <a class="reference internal nav-link" href="#id149">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id148">
+      <a class="reference internal nav-link" href="#id150">
        Aliases
       </a>
      </li>
@@ -2619,17 +2640,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id149">
+      <a class="reference internal nav-link" href="#id151">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id150">
+      <a class="reference internal nav-link" href="#id152">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id151">
+      <a class="reference internal nav-link" href="#id153">
        Aliases
       </a>
      </li>
@@ -2645,17 +2666,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id152">
+      <a class="reference internal nav-link" href="#id154">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id153">
+      <a class="reference internal nav-link" href="#id155">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id154">
+      <a class="reference internal nav-link" href="#id156">
        Aliases
       </a>
      </li>
@@ -2671,17 +2692,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id155">
+      <a class="reference internal nav-link" href="#id157">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id156">
+      <a class="reference internal nav-link" href="#id158">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id157">
+      <a class="reference internal nav-link" href="#id159">
        Aliases
       </a>
      </li>
@@ -2715,17 +2736,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id158">
+      <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="#id159">
+      <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="#id160">
+      <a class="reference internal nav-link" href="#id162">
        Aliases
       </a>
      </li>
@@ -2741,17 +2762,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id161">
+      <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="#id162">
+      <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="#id163">
+      <a class="reference internal nav-link" href="#id165">
        Aliases
       </a>
      </li>
@@ -2767,17 +2788,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id164">
+      <a class="reference internal nav-link" href="#id166">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id165">
+      <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="#id166">
+      <a class="reference internal nav-link" href="#id168">
        Aliases
       </a>
      </li>
@@ -2793,17 +2814,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id167">
+      <a class="reference internal nav-link" href="#id169">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id168">
+      <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="#id169">
+      <a class="reference internal nav-link" href="#id171">
        Aliases
       </a>
      </li>
@@ -2819,17 +2840,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id170">
+      <a class="reference internal nav-link" href="#id172">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id171">
+      <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="#id172">
+      <a class="reference internal nav-link" href="#id174">
        Aliases
       </a>
      </li>
@@ -2845,17 +2866,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id173">
+      <a class="reference internal nav-link" href="#id175">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id174">
+      <a class="reference internal nav-link" href="#id176">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id175">
+      <a class="reference internal nav-link" href="#id177">
        Aliases
       </a>
      </li>
@@ -2871,17 +2892,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id176">
+      <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="#id177">
+      <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="#id178">
+      <a class="reference internal nav-link" href="#id180">
        Aliases
       </a>
      </li>
@@ -2897,17 +2918,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id179">
+      <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="#id180">
+      <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="#id181">
+      <a class="reference internal nav-link" href="#id183">
        Aliases
       </a>
      </li>
@@ -2923,17 +2944,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id182">
+      <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="#id183">
+      <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="#id184">
+      <a class="reference internal nav-link" href="#id186">
        Aliases
       </a>
      </li>
@@ -2949,17 +2970,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id185">
+      <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="#id186">
+      <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="#id187">
+      <a class="reference internal nav-link" href="#id189">
        Aliases
       </a>
      </li>
@@ -2975,17 +2996,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id188">
+      <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="#id189">
+      <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="#id190">
+      <a class="reference internal nav-link" href="#id192">
        Aliases
       </a>
      </li>
@@ -3001,17 +3022,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id191">
+      <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="#id192">
+      <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="#id193">
+      <a class="reference internal nav-link" href="#id195">
        Aliases
       </a>
      </li>
@@ -3027,12 +3048,12 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id194">
+      <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="#id195">
+      <a class="reference internal nav-link" href="#id197">
        Example
       </a>
      </li>
@@ -3048,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="#id196">
+      <a class="reference internal nav-link" href="#id198">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id197">
+      <a class="reference internal nav-link" href="#id199">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id198">
+      <a class="reference internal nav-link" href="#id200">
        Aliases
       </a>
      </li>
@@ -3074,12 +3095,12 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id199">
+      <a class="reference internal nav-link" href="#id201">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id200">
+      <a class="reference internal nav-link" href="#id202">
        Example
       </a>
      </li>
@@ -3437,17 +3458,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="#id203">
        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="#id204">
        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="#id205">
        Aliases
       </a>
      </li>
@@ -3472,12 +3493,12 @@
     </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="#id206">
        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="#id207">
        Aliases
       </a>
      </li>
@@ -3502,7 +3523,7 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id206">
+      <a class="reference internal nav-link" href="#id208">
        Arguments
       </a>
      </li>
@@ -3518,12 +3539,12 @@
     </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="#id209">
        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="#id210">
        Aliases
       </a>
      </li>
@@ -3546,7 +3567,7 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id209">
+      <a class="reference internal nav-link" href="#id211">
        Arguments
       </a>
      </li>
@@ -3562,7 +3583,7 @@
     </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="#id212">
        Arguments
       </a>
      </li>
@@ -3585,7 +3606,7 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id211">
+      <a class="reference internal nav-link" href="#id213">
        Arguments
       </a>
      </li>
@@ -3601,7 +3622,7 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id212">
+      <a class="reference internal nav-link" href="#id214">
        Arguments
       </a>
      </li>
@@ -3617,7 +3638,7 @@
     </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="#id215">
        Arguments
       </a>
      </li>
@@ -3633,7 +3654,7 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id214">
+      <a class="reference internal nav-link" href="#id216">
        Arguments
       </a>
      </li>
@@ -3649,7 +3670,7 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id215">
+      <a class="reference internal nav-link" href="#id217">
        Arguments
       </a>
      </li>
@@ -3665,7 +3686,7 @@
     </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="#id218">
        Arguments
       </a>
      </li>
@@ -3688,12 +3709,12 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id217">
+      <a class="reference internal nav-link" href="#id219">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id218">
+      <a class="reference internal nav-link" href="#id220">
        Example
       </a>
      </li>
@@ -3709,12 +3730,12 @@
     </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="#id221">
        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="#id222">
        Example
       </a>
      </li>
@@ -5286,6 +5307,7 @@ not appear in <code class="docutils literal 
notranslate"><span class="pre">origs
 <li><p><a class="reference internal" 
href="#to-timestamp-seconds">to_timestamp_seconds</a></p></li>
 <li><p><a class="reference internal" 
href="#to-timestamp-nanos">to_timestamp_nanos</a></p></li>
 <li><p><a class="reference internal" 
href="#from-unixtime">from_unixtime</a></p></li>
+<li><p><a class="reference internal" 
href="#to-unixtime">to_unixtime</a></p></li>
 </ul>
 <section id="now">
 <h3><code class="docutils literal notranslate"><span 
class="pre">now</span></code><a class="headerlink" href="#now" title="Link to 
this heading">¶</a></h3>
@@ -5781,9 +5803,45 @@ Can be a constant, column, or function, and any 
combination of arithmetic operat
 </ul>
 </section>
 </section>
-</section>
-<section id="array-functions">
-<h2>Array Functions<a class="headerlink" href="#array-functions" title="Link 
to this heading">¶</a></h2>
+<section id="to-unixtime">
+<h3><code class="docutils literal notranslate"><span 
class="pre">to_unixtime</span></code><a class="headerlink" href="#to-unixtime" 
title="Link to this heading">¶</a></h3>
+<p>Converts a value to seconds since the unix epoch (<code class="docutils 
literal notranslate"><span class="pre">1970-01-01T00:00:00Z</span></code>).
+Supports strings, dates, timestamps and double types as input.
+Strings are parsed as RFC3339 (e.g. ‘2023-07-20T05:44:00’) if no [Chrono 
formats] are provided.</p>
+<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="id105">
+<h4>Arguments<a class="headerlink" href="#id105" 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="id106">
+<h4>Example<a class="headerlink" href="#id106" title="Link to this 
heading">¶</a></h4>
+<div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</span> <span 
class="n">select</span> <span class="n">to_unixtime</span><span 
class="p">(</span><span 
class="s1">&#39;2020-09-08T12:00:00+00:00&#39;</span><span class="p">);</span>
+<span class="o">+------------------------------------------------+</span>
+<span class="o">|</span> <span class="n">to_unixtime</span><span 
class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span 
class="s2">&quot;2020-09-08T12:00:00+00:00&quot;</span><span 
class="p">))</span> <span class="o">|</span>
+<span class="o">+------------------------------------------------+</span>
+<span class="o">|</span> <span class="mi">1599566400</span>                    
                 <span class="o">|</span>
+<span class="o">+------------------------------------------------+</span>
+<span class="o">&gt;</span> <span class="n">select</span> <span 
class="n">to_unixtime</span><span class="p">(</span><span 
class="s1">&#39;01-14-2023 01:01:30+05:30&#39;</span><span class="p">,</span> 
<span class="s1">&#39;%q&#39;</span><span class="p">,</span> <span 
class="s1">&#39;</span><span class="si">%d</span><span class="s1">-%m-%Y 
%H/%M/%S&#39;</span><span class="p">,</span> <span 
class="s1">&#39;%+&#39;</span><span class="p">,</span> <span 
class="s1">&#39;%m-</span><span class="s [...]
+<span 
class="o">+-----------------------------------------------------------------------------------------------------------------------------+</span>
+<span class="o">|</span> <span class="n">to_unixtime</span><span 
class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span 
class="s2">&quot;01-14-2023 01:01:30+05:30&quot;</span><span 
class="p">),</span><span class="n">Utf8</span><span class="p">(</span><span 
class="s2">&quot;%q&quot;</span><span class="p">),</span><span 
class="n">Utf8</span><span class="p">(</span><span 
class="s2">&quot;</span><span class="si">%d</span><span class="s2">-%m-%Y 
%H/%M/%S&quot;</span><span  [...]
+<span 
class="o">+-----------------------------------------------------------------------------------------------------------------------------+</span>
+<span class="o">|</span> <span class="mi">1673638290</span>                    
                                                                                
              <span class="o">|</span>
+<span 
class="o">+-----------------------------------------------------------------------------------------------------------------------------+</span>
+</pre></div>
+</div>
+</section>
+</section>
+</section>
+<section id="array-functions">
+<h2>Array Functions<a class="headerlink" href="#array-functions" title="Link 
to this heading">¶</a></h2>
 <ul class="simple">
 <li><p><a class="reference internal" 
href="#array-append">array_append</a></p></li>
 <li><p><a class="reference internal" href="#array-sort">array_sort</a></p></li>
@@ -5876,16 +5934,16 @@ Can be a constant, column, or function, and any 
combination of arithmetic operat
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_append</span><span 
class="p">(</span><span class="n">array</span><span class="p">,</span> <span 
class="n">element</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id105">
-<h4>Arguments<a class="headerlink" href="#id105" title="Link to this 
heading">¶</a></h4>
+<section id="id107">
+<h4>Arguments<a class="headerlink" href="#id107" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
 <li><p><strong>element</strong>: Element to append to the array.</p></li>
 </ul>
 </section>
-<section id="id106">
-<h4>Example<a class="headerlink" href="#id106" title="Link to this 
heading">¶</a></h4>
+<section id="id108">
+<h4>Example<a class="headerlink" href="#id108" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</span> <span 
class="n">select</span> <span class="n">array_append</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="o">+--------------------------------------+</span>
 <span class="o">|</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="o">|</span>
@@ -5895,8 +5953,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </pre></div>
 </div>
 </section>
-<section id="id107">
-<h4>Aliases<a class="headerlink" href="#id107" title="Link to this 
heading">¶</a></h4>
+<section id="id109">
+<h4>Aliases<a class="headerlink" href="#id109" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>array_push_back</p></li>
 <li><p>list_append</p></li>
@@ -5910,8 +5968,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_sort</span><span 
class="p">(</span><span class="n">array</span><span class="p">,</span> <span 
class="n">desc</span><span class="p">,</span> <span 
class="n">nulls_first</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id108">
-<h4>Arguments<a class="headerlink" href="#id108" title="Link to this 
heading">¶</a></h4>
+<section id="id110">
+<h4>Arguments<a class="headerlink" href="#id110" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
@@ -5919,8 +5977,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <li><p><strong>nulls_first</strong>: Whether to sort nulls first(<code 
class="docutils literal notranslate"><span class="pre">NULLS</span> <span 
class="pre">FIRST</span></code> or <code class="docutils literal 
notranslate"><span class="pre">NULLS</span> <span 
class="pre">LAST</span></code>).</p></li>
 </ul>
 </section>
-<section id="id109">
-<h4>Example<a class="headerlink" href="#id109" title="Link to this 
heading">¶</a></h4>
+<section id="id111">
+<h4>Example<a class="headerlink" href="#id111" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</span> <span 
class="n">select</span> <span class="n">array_sort</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="o">+-----------------------------+</span>
 <span class="o">|</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="o">|</span>
@@ -5930,8 +5988,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </pre></div>
 </div>
 </section>
-<section id="id110">
-<h4>Aliases<a class="headerlink" href="#id110" title="Link to this 
heading">¶</a></h4>
+<section id="id112">
+<h4>Aliases<a class="headerlink" href="#id112" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>list_sort</p></li>
 </ul>
@@ -5943,8 +6001,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_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="id111">
-<h4>Arguments<a class="headerlink" href="#id111" title="Link to this 
heading">¶</a></h4>
+<section id="id113">
+<h4>Arguments<a class="headerlink" href="#id113" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
@@ -5952,8 +6010,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <li><p><strong>value</strong>: Defines new elements’ value or empty if value 
is not set.</p></li>
 </ul>
 </section>
-<section id="id112">
-<h4>Example<a class="headerlink" href="#id112" title="Link to this 
heading">¶</a></h4>
+<section id="id114">
+<h4>Example<a class="headerlink" href="#id114" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</span> <span 
class="n">select</span> <span class="n">array_resize</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="o">+-------------------------------------+</span>
 <span class="o">|</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="o">|</span>
@@ -5963,8 +6021,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </pre></div>
 </div>
 </section>
-<section id="id113">
-<h4>Aliases<a class="headerlink" href="#id113" title="Link to this 
heading">¶</a></h4>
+<section id="id115">
+<h4>Aliases<a class="headerlink" href="#id115" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>list_resize</p></li>
 </ul>
@@ -5980,16 +6038,16 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_concat</span><span 
class="p">(</span><span class="n">array</span><span class="p">[,</span> <span 
class="o">...</span><span class="p">,</span> <span 
class="n">array_n</span><span class="p">])</span>
 </pre></div>
 </div>
-<section id="id114">
-<h4>Arguments<a class="headerlink" href="#id114" title="Link to this 
heading">¶</a></h4>
+<section id="id116">
+<h4>Arguments<a class="headerlink" href="#id116" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array</strong>: Array expression to concatenate.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
 <li><p><strong>array_n</strong>: Subsequent array column or literal array to 
concatenate.</p></li>
 </ul>
 </section>
-<section id="id115">
-<h4>Example<a class="headerlink" href="#id115" title="Link to this 
heading">¶</a></h4>
+<section id="id117">
+<h4>Example<a class="headerlink" href="#id117" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</span> <span 
class="n">select</span> <span class="n">array_concat</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="p">[</span><span 
class="mi">3</span><span class="p">,</span> <span class="mi">4</span><span 
class="p">],</span> <span class="p">[</span><span class="mi">5</span><span 
class="p" [...]
 <span class="o">+---------------------------------------------------+</span>
 <span class="o">|</span> <span class="n">array_concat</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="n">List</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">List</span><span class="p">([</span><span 
class="mi">5</span><span class="p">,</span><sp [...]
@@ -5999,8 +6057,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </pre></div>
 </div>
 </section>
-<section id="id116">
-<h4>Aliases<a class="headerlink" href="#id116" title="Link to this 
heading">¶</a></h4>
+<section id="id118">
+<h4>Aliases<a class="headerlink" href="#id118" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>array_cat</p></li>
 <li><p>list_cat</p></li>
@@ -6018,8 +6076,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_has</span><span 
class="p">(</span><span class="n">array</span><span class="p">,</span> <span 
class="n">element</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id117">
-<h4>Arguments<a class="headerlink" href="#id117" title="Link to this 
heading">¶</a></h4>
+<section id="id119">
+<h4>Arguments<a class="headerlink" href="#id119" 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>
@@ -6027,8 +6085,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
 </ul>
 </section>
-<section id="id118">
-<h4>Aliases<a class="headerlink" href="#id118" title="Link to this 
heading">¶</a></h4>
+<section id="id120">
+<h4>Aliases<a class="headerlink" href="#id120" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>list_has</p></li>
 </ul>
@@ -6040,8 +6098,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_has_all</span><span 
class="p">(</span><span class="n">array</span><span class="p">,</span> <span 
class="n">sub</span><span class="o">-</span><span class="n">array</span><span 
class="p">)</span>
 </pre></div>
 </div>
-<section id="id119">
-<h4>Arguments<a class="headerlink" href="#id119" title="Link to this 
heading">¶</a></h4>
+<section id="id121">
+<h4>Arguments<a class="headerlink" href="#id121" 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>
@@ -6049,8 +6107,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
 </ul>
 </section>
-<section id="id120">
-<h4>Aliases<a class="headerlink" href="#id120" title="Link to this 
heading">¶</a></h4>
+<section id="id122">
+<h4>Aliases<a class="headerlink" href="#id122" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>list_has_all</p></li>
 </ul>
@@ -6062,8 +6120,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_has_any</span><span 
class="p">(</span><span class="n">array</span><span class="p">,</span> <span 
class="n">sub</span><span class="o">-</span><span class="n">array</span><span 
class="p">)</span>
 </pre></div>
 </div>
-<section id="id121">
-<h4>Arguments<a class="headerlink" href="#id121" title="Link to this 
heading">¶</a></h4>
+<section id="id123">
+<h4>Arguments<a class="headerlink" href="#id123" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
@@ -6071,8 +6129,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
 </ul>
 </section>
-<section id="id122">
-<h4>Aliases<a class="headerlink" href="#id122" title="Link to this 
heading">¶</a></h4>
+<section id="id124">
+<h4>Aliases<a class="headerlink" href="#id124" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>list_has_any</p></li>
 </ul>
@@ -6084,15 +6142,15 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_dims</span><span 
class="p">(</span><span class="n">array</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id123">
-<h4>Arguments<a class="headerlink" href="#id123" title="Link to this 
heading">¶</a></h4>
+<section id="id125">
+<h4>Arguments<a class="headerlink" href="#id125" 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="id124">
-<h4>Example<a class="headerlink" href="#id124" title="Link to this 
heading">¶</a></h4>
+<section id="id126">
+<h4>Example<a class="headerlink" href="#id126" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</span> <span 
class="n">select</span> <span class="n">array_dims</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="p">[</span><span class="mi">4</span><span 
class="p">,</span> <span class="mi">5</span><span class="p">,</span> <span 
class="mi" [...]
 <span class="o">+---------------------------------+</span>
 <span class="o">|</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="o">|</span>
@@ -6102,8 +6160,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </pre></div>
 </div>
 </section>
-<section id="id125">
-<h4>Aliases<a class="headerlink" href="#id125" title="Link to this 
heading">¶</a></h4>
+<section id="id127">
+<h4>Aliases<a class="headerlink" href="#id127" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>list_dims</p></li>
 </ul>
@@ -6115,15 +6173,15 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_distinct</span><span 
class="p">(</span><span class="n">array</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id126">
-<h4>Arguments<a class="headerlink" href="#id126" title="Link to this 
heading">¶</a></h4>
+<section id="id128">
+<h4>Arguments<a class="headerlink" href="#id128" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
 </ul>
 </section>
-<section id="id127">
-<h4>Example<a class="headerlink" href="#id127" title="Link to this 
heading">¶</a></h4>
+<section id="id129">
+<h4>Example<a class="headerlink" href="#id129" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</span> <span 
class="n">select</span> <span class="n">array_distinct</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="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">2</span><span 
class=" [...]
 <span class="o">+---------------------------------+</span>
 <span class="o">|</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="o">|</span>
@@ -6133,8 +6191,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </pre></div>
 </div>
 </section>
-<section id="id128">
-<h4>Aliases<a class="headerlink" href="#id128" title="Link to this 
heading">¶</a></h4>
+<section id="id130">
+<h4>Aliases<a class="headerlink" href="#id130" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>list_distinct</p></li>
 </ul>
@@ -6146,16 +6204,16 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_element</span><span 
class="p">(</span><span class="n">array</span><span class="p">,</span> <span 
class="n">index</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id129">
-<h4>Arguments<a class="headerlink" href="#id129" title="Link to this 
heading">¶</a></h4>
+<section id="id131">
+<h4>Arguments<a class="headerlink" href="#id131" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
 <li><p><strong>index</strong>: Index to extract the element from the 
array.</p></li>
 </ul>
 </section>
-<section id="id130">
-<h4>Example<a class="headerlink" href="#id130" title="Link to this 
heading">¶</a></h4>
+<section id="id132">
+<h4>Example<a class="headerlink" href="#id132" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</span> <span 
class="n">select</span> <span class="n">array_element</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">3</span><span class="p">);</span>
 <span class="o">+-----------------------------------------+</span>
 <span class="o">|</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="o">|</span>
@@ -6165,8 +6223,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </pre></div>
 </div>
 </section>
-<section id="id131">
-<h4>Aliases<a class="headerlink" href="#id131" title="Link to this 
heading">¶</a></h4>
+<section id="id133">
+<h4>Aliases<a class="headerlink" href="#id133" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>array_extract</p></li>
 <li><p>list_element</p></li>
@@ -6185,8 +6243,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_fill</span><span 
class="p">(</span><span class="n">element</span><span class="p">,</span> <span 
class="n">array</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id132">
-<h4>Arguments<a class="headerlink" href="#id132" title="Link to this 
heading">¶</a></h4>
+<section id="id134">
+<h4>Arguments<a class="headerlink" href="#id134" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
@@ -6202,8 +6260,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <li><p>Does not change arrays that are already flat</p></li>
 </ul>
 <p>The flattened array contains all the elements from all source arrays.</p>
-<section id="id133">
-<h4>Arguments<a class="headerlink" href="#id133" 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>array</strong>: Array expression
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
@@ -6223,8 +6281,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_intersect</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="id134">
-<h4>Arguments<a class="headerlink" href="#id134" title="Link to this 
heading">¶</a></h4>
+<section id="id136">
+<h4>Arguments<a class="headerlink" href="#id136" 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>
@@ -6232,8 +6290,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
 </ul>
 </section>
-<section id="id135">
-<h4>Example<a class="headerlink" href="#id135" title="Link to this 
heading">¶</a></h4>
+<section id="id137">
+<h4>Example<a class="headerlink" href="#id137" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</span> <span 
class="n">select</span> <span class="n">array_intersect</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="p">[</span><span class="mi">5</span><span class="p">,</span> <span 
class= [...]
 <span class="o">+----------------------------------------------------+</span>
 <span class="o">|</span> <span class="n">array_intersect</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="p">[</span><span class="mi">5</span><span class="p">,</span> <span 
class="mi">6</span><span class="p">,</span> <span class="mi">3</span><span 
class="p">,</span> <span class="mi">4</span><spa [...]
@@ -6250,8 +6308,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </div>
 </section>
 <hr class="docutils" />
-<section id="id136">
-<h4>Aliases<a class="headerlink" href="#id136" title="Link to this 
heading">¶</a></h4>
+<section id="id138">
+<h4>Aliases<a class="headerlink" href="#id138" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>list_intersect</p></li>
 </ul>
@@ -6267,16 +6325,16 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_length</span><span 
class="p">(</span><span class="n">array</span><span class="p">,</span> <span 
class="n">dimension</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id137">
-<h4>Arguments<a class="headerlink" href="#id137" title="Link to this 
heading">¶</a></h4>
+<section id="id139">
+<h4>Arguments<a class="headerlink" href="#id139" 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="id138">
-<h4>Example<a class="headerlink" href="#id138" title="Link to this 
heading">¶</a></h4>
+<section id="id140">
+<h4>Example<a class="headerlink" href="#id140" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</span> <span 
class="n">select</span> <span class="n">array_length</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="o">+---------------------------------+</span>
 <span class="o">|</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="o">|</span>
@@ -6286,8 +6344,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </pre></div>
 </div>
 </section>
-<section id="id139">
-<h4>Aliases<a class="headerlink" href="#id139" title="Link to this 
heading">¶</a></h4>
+<section id="id141">
+<h4>Aliases<a class="headerlink" href="#id141" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>list_length</p></li>
 </ul>
@@ -6299,15 +6357,15 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_ndims</span><span 
class="p">(</span><span class="n">array</span><span class="p">,</span> <span 
class="n">element</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id140">
-<h4>Arguments<a class="headerlink" href="#id140" title="Link to this 
heading">¶</a></h4>
+<section id="id142">
+<h4>Arguments<a class="headerlink" href="#id142" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
 </ul>
 </section>
-<section id="id141">
-<h4>Example<a class="headerlink" href="#id141" title="Link to this 
heading">¶</a></h4>
+<section id="id143">
+<h4>Example<a class="headerlink" href="#id143" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</span> <span 
class="n">select</span> <span class="n">array_ndims</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="p">[</span><span class="mi">4</span><span 
class="p">,</span> <span class="mi">5</span><span class="p">,</span> <span 
class="mi [...]
 <span class="o">+----------------------------------+</span>
 <span class="o">|</span> <span class="n">array_ndims</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="o">|</span>
@@ -6317,8 +6375,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </pre></div>
 </div>
 </section>
-<section id="id142">
-<h4>Aliases<a class="headerlink" href="#id142" title="Link to this 
heading">¶</a></h4>
+<section id="id144">
+<h4>Aliases<a class="headerlink" href="#id144" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>list_ndims</p></li>
 </ul>
@@ -6330,16 +6388,16 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_prepend</span><span 
class="p">(</span><span class="n">element</span><span class="p">,</span> <span 
class="n">array</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id143">
-<h4>Arguments<a class="headerlink" href="#id143" 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>element</strong>: Element to prepend to the array.</p></li>
 <li><p><strong>array</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
 </ul>
 </section>
-<section id="id144">
-<h4>Example<a class="headerlink" href="#id144" title="Link to this 
heading">¶</a></h4>
+<section id="id146">
+<h4>Example<a class="headerlink" href="#id146" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</span> <span 
class="n">select</span> <span class="n">array_prepend</span><span 
class="p">(</span><span class="mi">1</span><span class="p">,</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="o">+---------------------------------------+</span>
 <span class="o">|</span> <span class="n">array_prepend</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">List</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="o">|</span>
@@ -6349,8 +6407,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </pre></div>
 </div>
 </section>
-<section id="id145">
-<h4>Aliases<a class="headerlink" href="#id145" title="Link to this 
heading">¶</a></h4>
+<section id="id147">
+<h4>Aliases<a class="headerlink" href="#id147" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>array_push_front</p></li>
 <li><p>list_prepend</p></li>
@@ -6364,15 +6422,15 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_pop_front</span><span 
class="p">(</span><span class="n">array</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id146">
-<h4>Arguments<a class="headerlink" href="#id146" title="Link to this 
heading">¶</a></h4>
+<section id="id148">
+<h4>Arguments<a class="headerlink" href="#id148" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
 </ul>
 </section>
-<section id="id147">
-<h4>Example<a class="headerlink" href="#id147" title="Link to this 
heading">¶</a></h4>
+<section id="id149">
+<h4>Example<a class="headerlink" href="#id149" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</span> <span 
class="n">select</span> <span class="n">array_pop_front</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="o">+-------------------------------+</span>
 <span class="o">|</span> <span class="n">array_pop_front</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="o">|</span>
@@ -6382,8 +6440,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </pre></div>
 </div>
 </section>
-<section id="id148">
-<h4>Aliases<a class="headerlink" href="#id148" title="Link to this 
heading">¶</a></h4>
+<section id="id150">
+<h4>Aliases<a class="headerlink" href="#id150" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>list_pop_front</p></li>
 </ul>
@@ -6395,15 +6453,15 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_pop_back</span><span 
class="p">(</span><span class="n">array</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id149">
-<h4>Arguments<a class="headerlink" href="#id149" title="Link to this 
heading">¶</a></h4>
+<section id="id151">
+<h4>Arguments<a class="headerlink" href="#id151" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
 </ul>
 </section>
-<section id="id150">
-<h4>Example<a class="headerlink" href="#id150" title="Link to this 
heading">¶</a></h4>
+<section id="id152">
+<h4>Example<a class="headerlink" href="#id152" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</span> <span 
class="n">select</span> <span class="n">array_pop_back</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="o">+-------------------------------+</span>
 <span class="o">|</span> <span class="n">array_pop_back</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="o">|</span>
@@ -6413,8 +6471,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </pre></div>
 </div>
 </section>
-<section id="id151">
-<h4>Aliases<a class="headerlink" href="#id151" title="Link to this 
heading">¶</a></h4>
+<section id="id153">
+<h4>Aliases<a class="headerlink" href="#id153" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>list_pop_back</p></li>
 </ul>
@@ -6427,8 +6485,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <span class="n">array_position</span><span class="p">(</span><span 
class="n">array</span><span class="p">,</span> <span 
class="n">element</span><span class="p">,</span> <span 
class="n">index</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id152">
-<h4>Arguments<a class="headerlink" href="#id152" title="Link to this 
heading">¶</a></h4>
+<section id="id154">
+<h4>Arguments<a class="headerlink" href="#id154" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
@@ -6436,8 +6494,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <li><p><strong>index</strong>: Index at which to start searching.</p></li>
 </ul>
 </section>
-<section id="id153">
-<h4>Example<a class="headerlink" href="#id153" title="Link to this 
heading">¶</a></h4>
+<section id="id155">
+<h4>Example<a class="headerlink" href="#id155" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</span> <span 
class="n">select</span> <span class="n">array_position</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=" [...]
 <span class="o">+----------------------------------------------+</span>
 <span class="o">|</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 class="p">(</span><span  [...]
@@ -6447,8 +6505,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </pre></div>
 </div>
 </section>
-<section id="id154">
-<h4>Aliases<a class="headerlink" href="#id154" title="Link to this 
heading">¶</a></h4>
+<section id="id156">
+<h4>Aliases<a class="headerlink" href="#id156" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>array_indexof</p></li>
 <li><p>list_indexof</p></li>
@@ -6462,16 +6520,16 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_positions</span><span 
class="p">(</span><span class="n">array</span><span class="p">,</span> <span 
class="n">element</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id155">
-<h4>Arguments<a class="headerlink" href="#id155" title="Link to this 
heading">¶</a></h4>
+<section id="id157">
+<h4>Arguments<a class="headerlink" href="#id157" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
 <li><p><strong>element</strong>: Element to search for positions in the 
array.</p></li>
 </ul>
 </section>
-<section id="id156">
-<h4>Example<a class="headerlink" href="#id156" title="Link to this 
heading">¶</a></h4>
+<section id="id158">
+<h4>Example<a class="headerlink" href="#id158" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</span> <span 
class="n">select</span> <span class="n">array_positions</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= [...]
 <span class="o">+-----------------------------------------------+</span>
 <span class="o">|</span> <span class="n">array_positions</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 class="p">(</span><span [...]
@@ -6481,8 +6539,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </pre></div>
 </div>
 </section>
-<section id="id157">
-<h4>Aliases<a class="headerlink" href="#id157" 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_positions</p></li>
 </ul>
@@ -6502,16 +6560,16 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_repeat</span><span 
class="p">(</span><span class="n">element</span><span class="p">,</span> <span 
class="n">count</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id158">
-<h4>Arguments<a class="headerlink" href="#id158" 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>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="id159">
-<h4>Example<a class="headerlink" href="#id159" 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-default notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</span> <span 
class="n">select</span> <span class="n">array_repeat</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="o">|</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="o">|</span>
@@ -6529,8 +6587,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </pre></div>
 </div>
 </section>
-<section id="id160">
-<h4>Aliases<a class="headerlink" href="#id160" 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_repeat</p></li>
 </ul>
@@ -6542,16 +6600,16 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_remove</span><span 
class="p">(</span><span class="n">array</span><span class="p">,</span> <span 
class="n">element</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id161">
-<h4>Arguments<a class="headerlink" href="#id161" 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 be removed from the array.</p></li>
 </ul>
 </section>
-<section id="id162">
-<h4>Example<a class="headerlink" href="#id162" 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-default notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</span> <span 
class="n">select</span> <span class="n">array_remove</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 class="o">+----------------------------------------------+</span>
 <span class="o">|</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">]),</span><span class [...]
@@ -6561,8 +6619,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </pre></div>
 </div>
 </section>
-<section id="id163">
-<h4>Aliases<a class="headerlink" href="#id163" title="Link to this 
heading">¶</a></h4>
+<section id="id165">
+<h4>Aliases<a class="headerlink" href="#id165" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>list_remove</p></li>
 </ul>
@@ -6574,8 +6632,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_remove_n</span><span 
class="p">(</span><span class="n">array</span><span class="p">,</span> <span 
class="n">element</span><span class="p">,</span> <span 
class="nb">max</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id164">
-<h4>Arguments<a class="headerlink" href="#id164" title="Link to this 
heading">¶</a></h4>
+<section id="id166">
+<h4>Arguments<a class="headerlink" href="#id166" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
@@ -6583,8 +6641,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <li><p><strong>max</strong>: Number of first occurrences to remove.</p></li>
 </ul>
 </section>
-<section id="id165">
-<h4>Example<a class="headerlink" href="#id165" 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-default notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</span> <span 
class="n">select</span> <span class="n">array_remove_n</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=" [...]
 <span 
class="o">+---------------------------------------------------------+</span>
 <span class="o">|</span> <span class="n">array_remove_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="p">]),</span><span cla [...]
@@ -6594,8 +6652,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </pre></div>
 </div>
 </section>
-<section id="id166">
-<h4>Aliases<a class="headerlink" href="#id166" 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_remove_n</p></li>
 </ul>
@@ -6607,16 +6665,16 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span 
class="n">array_remove_all</span><span class="p">(</span><span 
class="n">array</span><span class="p">,</span> <span 
class="n">element</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id167">
-<h4>Arguments<a class="headerlink" href="#id167" title="Link to this 
heading">¶</a></h4>
+<section id="id169">
+<h4>Arguments<a class="headerlink" href="#id169" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>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="id168">
-<h4>Example<a class="headerlink" href="#id168" 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-default notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</span> <span 
class="n">select</span> <span class="n">array_remove_all</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 [...]
 <span class="o">+--------------------------------------------------+</span>
 <span class="o">|</span> <span class="n">array_remove_all</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">]),</span><span c [...]
@@ -6626,8 +6684,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </pre></div>
 </div>
 </section>
-<section id="id169">
-<h4>Aliases<a class="headerlink" href="#id169" 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_remove_all</p></li>
 </ul>
@@ -6639,8 +6697,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_replace</span><span 
class="p">(</span><span class="n">array</span><span class="p">,</span> <span 
class="n">from</span><span class="p">,</span> <span class="n">to</span><span 
class="p">)</span>
 </pre></div>
 </div>
-<section id="id170">
-<h4>Arguments<a class="headerlink" href="#id170" title="Link to this 
heading">¶</a></h4>
+<section id="id172">
+<h4>Arguments<a class="headerlink" href="#id172" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
@@ -6648,8 +6706,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <li><p><strong>to</strong>: Final element.</p></li>
 </ul>
 </section>
-<section id="id171">
-<h4>Example<a class="headerlink" href="#id171" 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-default notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</span> <span 
class="n">select</span> <span class="n">array_replace</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 
class="o">+--------------------------------------------------------+</span>
 <span class="o">|</span> <span class="n">array_replace</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">]),</span><span clas [...]
@@ -6659,8 +6717,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </pre></div>
 </div>
 </section>
-<section id="id172">
-<h4>Aliases<a class="headerlink" href="#id172" 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_replace</p></li>
 </ul>
@@ -6672,8 +6730,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_replace_n</span><span 
class="p">(</span><span class="n">array</span><span class="p">,</span> <span 
class="n">from</span><span class="p">,</span> <span class="n">to</span><span 
class="p">,</span> <span class="nb">max</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id173">
-<h4>Arguments<a class="headerlink" href="#id173" title="Link to this 
heading">¶</a></h4>
+<section id="id175">
+<h4>Arguments<a class="headerlink" href="#id175" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
@@ -6682,8 +6740,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <li><p><strong>max</strong>: Number of first occurrences to replace.</p></li>
 </ul>
 </section>
-<section id="id174">
-<h4>Example<a class="headerlink" href="#id174" title="Link to this 
heading">¶</a></h4>
+<section id="id176">
+<h4>Example<a class="headerlink" href="#id176" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</span> <span 
class="n">select</span> <span class="n">array_replace_n</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= [...]
 <span 
class="o">+-------------------------------------------------------------------+</span>
 <span class="o">|</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="p">]),</span><span cl [...]
@@ -6693,8 +6751,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </pre></div>
 </div>
 </section>
-<section id="id175">
-<h4>Aliases<a class="headerlink" href="#id175" 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>list_replace_n</p></li>
 </ul>
@@ -6706,8 +6764,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span 
class="n">array_replace_all</span><span class="p">(</span><span 
class="n">array</span><span class="p">,</span> <span class="n">from</span><span 
class="p">,</span> <span class="n">to</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id176">
-<h4>Arguments<a class="headerlink" href="#id176" 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>array</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
@@ -6715,8 +6773,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <li><p><strong>to</strong>: Final element.</p></li>
 </ul>
 </section>
-<section id="id177">
-<h4>Example<a class="headerlink" href="#id177" 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-default notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</span> <span 
class="n">select</span> <span class="n">array_replace_all</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 clas 
[...]
 <span 
class="o">+------------------------------------------------------------+</span>
 <span class="o">|</span> <span class="n">array_replace_all</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">]),</span><span  [...]
@@ -6726,8 +6784,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </pre></div>
 </div>
 </section>
-<section id="id178">
-<h4>Aliases<a class="headerlink" href="#id178" 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_replace_all</p></li>
 </ul>
@@ -6739,15 +6797,15 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_reverse</span><span 
class="p">(</span><span class="n">array</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id179">
-<h4>Arguments<a class="headerlink" href="#id179" 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>
 </ul>
 </section>
-<section id="id180">
-<h4>Example<a class="headerlink" href="#id180" 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-default notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</span> <span 
class="n">select</span> <span class="n">array_reverse</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="o">+------------------------------------------------------------+</span>
 <span class="o">|</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="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="o">|</span>
@@ -6757,8 +6815,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </pre></div>
 </div>
 </section>
-<section id="id181">
-<h4>Aliases<a class="headerlink" href="#id181" 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_reverse</p></li>
 </ul>
@@ -6770,8 +6828,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_slice</span><span 
class="p">(</span><span class="n">array</span><span class="p">,</span> <span 
class="n">begin</span><span class="p">,</span> <span class="n">end</span><span 
class="p">)</span>
 </pre></div>
 </div>
-<section id="id182">
-<h4>Arguments<a class="headerlink" href="#id182" 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>
@@ -6782,8 +6840,8 @@ If negative, it counts backward from the end of the 
array.</p></li>
 <li><p><strong>stride</strong>: Stride of the array slice. The default is 
1.</p></li>
 </ul>
 </section>
-<section id="id183">
-<h4>Example<a class="headerlink" href="#id183" 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-default notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</span> <span 
class="n">select</span> <span class="n">array_slice</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 
class="o">+--------------------------------------------------------+</span>
 <span class="o">|</span> <span class="n">array_slice</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">,</span><span class="m [...]
@@ -6793,8 +6851,8 @@ If negative, it counts backward from the end of the 
array.</p></li>
 </pre></div>
 </div>
 </section>
-<section id="id184">
-<h4>Aliases<a class="headerlink" href="#id184" 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_slice</p></li>
 </ul>
@@ -6806,16 +6864,16 @@ If negative, it counts backward from the end of the 
array.</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="id185">
-<h4>Arguments<a class="headerlink" href="#id185" 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>delimiter</strong>: Array element separator.</p></li>
 </ul>
 </section>
-<section id="id186">
-<h4>Example<a class="headerlink" href="#id186" 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-default notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</span> <span 
class="n">select</span> <span class="n">array_to_string</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="p">[</span><span class="mi">5</span><span class="p">,</span> <span class 
[...]
 <span class="o">+----------------------------------------------------+</span>
 <span class="o">|</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="p">,</span><span clas [...]
@@ -6825,8 +6883,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </pre></div>
 </div>
 </section>
-<section id="id187">
-<h4>Aliases<a class="headerlink" href="#id187" 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>array_join</p></li>
 <li><p>list_join</p></li>
@@ -6840,8 +6898,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_union</span><span 
class="p">(</span><span class="n">array1</span><span class="p">,</span> <span 
class="n">array2</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id188">
-<h4>Arguments<a class="headerlink" href="#id188" 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>array1</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
@@ -6849,8 +6907,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
 </ul>
 </section>
-<section id="id189">
-<h4>Example<a class="headerlink" href="#id189" 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-default notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</span> <span 
class="n">select</span> <span class="n">array_union</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="p">[</span><span class="mi">5</span><span class="p">,</span> <span 
class="mi" [...]
 <span class="o">+----------------------------------------------------+</span>
 <span class="o">|</span> <span class="n">array_union</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="p">[</span><span class="mi">5</span><span class="p">,</span> <span 
class="mi">6</span><span class="p">,</span> <span class="mi">3</span><span 
class="p">,</span> <span class="mi">4</span><span cl [...]
@@ -6867,8 +6925,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </div>
 </section>
 <hr class="docutils" />
-<section id="id190">
-<h4>Aliases<a class="headerlink" href="#id190" 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_union</p></li>
 </ul>
@@ -6880,8 +6938,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">array_except</span><span 
class="p">(</span><span class="n">array1</span><span class="p">,</span> <span 
class="n">array2</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id191">
-<h4>Arguments<a class="headerlink" href="#id191" 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>array1</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
@@ -6889,8 +6947,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
 </ul>
 </section>
-<section id="id192">
-<h4>Example<a class="headerlink" href="#id192" 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-default notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</span> <span 
class="n">select</span> <span class="n">array_except</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="p">[</span><span class="mi">5</span><span class="p">,</span> <span 
class="mi [...]
 <span class="o">+----------------------------------------------------+</span>
 <span class="o">|</span> <span class="n">array_except</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="p">[</span><span class="mi">5</span><span class="p">,</span> <span 
class="mi">6</span><span class="p">,</span> <span class="mi">3</span><span 
class="p">,</span> <span class="mi">4</span><span c [...]
@@ -6907,8 +6965,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </div>
 </section>
 <hr class="docutils" />
-<section id="id193">
-<h4>Aliases<a class="headerlink" href="#id193" 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_except</p></li>
 </ul>
@@ -6920,15 +6978,15 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">cardinality</span><span 
class="p">(</span><span class="n">array</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id194">
-<h4>Arguments<a class="headerlink" href="#id194" 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="id195">
-<h4>Example<a class="headerlink" href="#id195" 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-default notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</span> <span 
class="n">select</span> <span class="n">cardinality</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="p">[</span><span class="mi">5</span><span class="p">,</span> <span 
class="mi [...]
 <span class="o">+--------------------------------------+</span>
 <span class="o">|</span> <span class="n">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">,</span><span class="m [...]
@@ -6945,15 +7003,15 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">empty</span><span 
class="p">(</span><span class="n">array</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id196">
-<h4>Arguments<a class="headerlink" href="#id196" title="Link to this 
heading">¶</a></h4>
+<section id="id198">
+<h4>Arguments<a class="headerlink" href="#id198" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
 </ul>
 </section>
-<section id="id197">
-<h4>Example<a class="headerlink" href="#id197" title="Link to this 
heading">¶</a></h4>
+<section id="id199">
+<h4>Example<a class="headerlink" href="#id199" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</span> <span 
class="n">select</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="o">|</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="o">|</span>
@@ -6963,8 +7021,8 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </pre></div>
 </div>
 </section>
-<section id="id198">
-<h4>Aliases<a class="headerlink" href="#id198" title="Link to this 
heading">¶</a></h4>
+<section id="id200">
+<h4>Aliases<a class="headerlink" href="#id200" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>array_empty,</p></li>
 <li><p>list_empty</p></li>
@@ -6977,16 +7035,16 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">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="id199">
-<h4>Arguments<a class="headerlink" href="#id199" title="Link to this 
heading">¶</a></h4>
+<section id="id201">
+<h4>Arguments<a class="headerlink" href="#id201" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>start</strong>: start of the range</p></li>
 <li><p><strong>end</strong>: end of the range (included)</p></li>
 <li><p><strong>step</strong>: increase by step (can not be 0)</p></li>
 </ul>
 </section>
-<section id="id200">
-<h4>Example<a class="headerlink" href="#id200" title="Link to this 
heading">¶</a></h4>
+<section id="id202">
+<h4>Example<a class="headerlink" href="#id202" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</span> <span 
class="n">select</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="o">|</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="o">|</span>
@@ -7155,16 +7213,16 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <section id="array-empty">
 <h3><code class="docutils literal notranslate"><span 
class="pre">array_empty</span></code><a class="headerlink" href="#array-empty" 
title="Link to this heading">¶</a></h3>
 <p><em>Alias of <a class="reference internal" href="#empty">empty</a>.</em></p>
-<section id="id201">
-<h4>Arguments<a class="headerlink" href="#id201" title="Link to this 
heading">¶</a></h4>
+<section id="id203">
+<h4>Arguments<a class="headerlink" href="#id203" 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="id202">
-<h4>Example<a class="headerlink" href="#id202" title="Link to this 
heading">¶</a></h4>
+<section id="id204">
+<h4>Example<a class="headerlink" href="#id204" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</span> <span 
class="n">select</span> <span class="n">make_array</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="o">+----------------------------------------------------------+</span>
 <span class="o">|</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><span class="p">),</span><s [...]
@@ -7174,8 +7232,8 @@ string operators.</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="id205">
+<h4>Aliases<a class="headerlink" href="#id205" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>make_list</p></li>
 </ul>
@@ -7192,16 +7250,16 @@ string operators.</p></li>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">starts_with</span><span 
class="p">(</span><span class="nb">str</span><span class="p">,</span> <span 
class="n">delimiter</span><span class="p">[,</span> <span 
class="n">null_str</span><span class="p">])</span>
 </pre></div>
 </div>
-<section id="id204">
-<h4>Arguments<a class="headerlink" href="#id204" title="Link to this 
heading">¶</a></h4>
+<section id="id206">
+<h4>Arguments<a class="headerlink" href="#id206" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>str</strong>: String expression to split.</p></li>
 <li><p><strong>delimiter</strong>: Delimiter string to split on.</p></li>
 <li><p><strong>null_str</strong>: Substring values to be replaced with <code 
class="docutils literal notranslate"><span 
class="pre">NULL</span></code></p></li>
 </ul>
 </section>
-<section id="id205">
-<h4>Aliases<a class="headerlink" href="#id205" 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>string_to_list</p></li>
 </ul>
@@ -7218,8 +7276,8 @@ string operators.</p></li>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">trim_array</span><span 
class="p">(</span><span class="n">array</span><span class="p">,</span> <span 
class="n">n</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id206">
-<h4>Arguments<a class="headerlink" href="#id206" 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>
@@ -7251,16 +7309,16 @@ For example,</p>
 </pre></div>
 </div>
 <p>are not allowed</p>
-<section id="id207">
-<h4>Arguments<a class="headerlink" href="#id207" title="Link to this 
heading">¶</a></h4>
+<section id="id209">
+<h4>Arguments<a class="headerlink" href="#id209" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>start</strong>: start of the range</p></li>
 <li><p><strong>end</strong>: end of the range (not included)</p></li>
 <li><p><strong>step</strong>: increase by step (can not be 0)</p></li>
 </ul>
 </section>
-<section id="id208">
-<h4>Aliases<a class="headerlink" href="#id208" 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>generate_series</p></li>
 </ul>
@@ -7310,8 +7368,8 @@ select struct(a as field_a, b) from t;
 +--------------------------------------------------+
 </pre></div>
 </div>
-<section id="id209">
-<h4>Arguments<a class="headerlink" href="#id209" 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>expression_n</strong>: Expression to include in the output 
struct.
 Can be a constant, column, or function, any combination of arithmetic or
@@ -7344,8 +7402,8 @@ a struct type of fields <code class="docutils literal 
notranslate"><span class="
 <span 
class="o">+-------------------------------------------------------+</span>
 </pre></div>
 </div>
-<section id="id210">
-<h4>Arguments<a class="headerlink" href="#id210" title="Link to this 
heading">¶</a></h4>
+<section id="id212">
+<h4>Arguments<a class="headerlink" href="#id212" 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>
@@ -7372,8 +7430,8 @@ string operators.</p></li>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">digest</span><span 
class="p">(</span><span class="n">expression</span><span class="p">,</span> 
<span class="n">algorithm</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id211">
-<h4>Arguments<a class="headerlink" href="#id211" title="Link to this 
heading">¶</a></h4>
+<section id="id213">
+<h4>Arguments<a class="headerlink" href="#id213" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>expression</strong>: String expression to operate on.
 Can be a constant, column, or function, and any combination of string 
operators.</p></li>
@@ -7399,8 +7457,8 @@ Must be one of:</p>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">md5</span><span 
class="p">(</span><span class="n">expression</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id212">
-<h4>Arguments<a class="headerlink" href="#id212" 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>expression</strong>: String expression to operate on.
 Can be a constant, column, or function, and any combination of string 
operators.</p></li>
@@ -7413,8 +7471,8 @@ Can be a constant, column, or function, and any 
combination of string operators.
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">sha224</span><span 
class="p">(</span><span class="n">expression</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id213">
-<h4>Arguments<a class="headerlink" href="#id213" title="Link to this 
heading">¶</a></h4>
+<section id="id215">
+<h4>Arguments<a class="headerlink" href="#id215" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>expression</strong>: String expression to operate on.
 Can be a constant, column, or function, and any combination of string 
operators.</p></li>
@@ -7427,8 +7485,8 @@ Can be a constant, column, or function, and any 
combination of string operators.
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">sha256</span><span 
class="p">(</span><span class="n">expression</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id214">
-<h4>Arguments<a class="headerlink" href="#id214" title="Link to this 
heading">¶</a></h4>
+<section id="id216">
+<h4>Arguments<a class="headerlink" href="#id216" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>expression</strong>: String expression to operate on.
 Can be a constant, column, or function, and any combination of string 
operators.</p></li>
@@ -7441,8 +7499,8 @@ Can be a constant, column, or function, and any 
combination of string operators.
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">sha384</span><span 
class="p">(</span><span class="n">expression</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id215">
-<h4>Arguments<a class="headerlink" href="#id215" 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>expression</strong>: String expression to operate on.
 Can be a constant, column, or function, and any combination of string 
operators.</p></li>
@@ -7455,8 +7513,8 @@ Can be a constant, column, or function, and any 
combination of string operators.
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">sha512</span><span 
class="p">(</span><span class="n">expression</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id216">
-<h4>Arguments<a class="headerlink" href="#id216" title="Link to this 
heading">¶</a></h4>
+<section id="id218">
+<h4>Arguments<a class="headerlink" href="#id218" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>expression</strong>: String expression to operate on.
 Can be a constant, column, or function, and any combination of string 
operators.</p></li>
@@ -7476,8 +7534,8 @@ Can be a constant, column, or function, and any 
combination of string operators.
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">arrow_cast</span><span 
class="p">(</span><span class="n">expression</span><span class="p">,</span> 
<span class="n">datatype</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id217">
-<h4>Arguments<a class="headerlink" href="#id217" title="Link to this 
heading">¶</a></h4>
+<section id="id219">
+<h4>Arguments<a class="headerlink" href="#id219" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>expression</strong>: Expression to cast.
 Can be a constant, column, or function, and any combination of arithmetic or
@@ -7486,8 +7544,8 @@ string operators.</p></li>
 to cast to, as a string. The format is the same as that returned by [<code 
class="docutils literal notranslate"><span 
class="pre">arrow_typeof</span></code>]</p></li>
 </ul>
 </section>
-<section id="id218">
-<h4>Example<a class="headerlink" href="#id218" title="Link to this 
heading">¶</a></h4>
+<section id="id220">
+<h4>Example<a class="headerlink" href="#id220" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</span> <span 
class="n">select</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="s1">&#39;Int8&#39;</span><span 
class="p">)</span> <span class="k">as</span> <span class="n">a</span><span 
class="p">,</span>
   <span class="n">arrow_cast</span><span class="p">(</span><span 
class="s1">&#39;foo&#39;</span><span class="p">,</span> <span 
class="s1">&#39;Dictionary(Int32, Utf8)&#39;</span><span class="p">)</span> 
<span class="k">as</span> <span class="n">b</span><span class="p">,</span>
   <span class="n">arrow_cast</span><span class="p">(</span><span 
class="s1">&#39;bar&#39;</span><span class="p">,</span> <span 
class="s1">&#39;LargeUtf8&#39;</span><span class="p">)</span> <span 
class="k">as</span> <span class="n">c</span><span class="p">,</span>
@@ -7509,16 +7567,16 @@ to cast to, as a string. The format is the same as that 
returned by [<code class
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">arrow_typeof</span><span 
class="p">(</span><span class="n">expression</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id219">
-<h4>Arguments<a class="headerlink" href="#id219" title="Link to this 
heading">¶</a></h4>
+<section id="id221">
+<h4>Arguments<a class="headerlink" href="#id221" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>expression</strong>: Expression to evaluate.
 Can be a constant, column, or function, and any combination of arithmetic or
 string operators.</p></li>
 </ul>
 </section>
-<section id="id220">
-<h4>Example<a class="headerlink" href="#id220" title="Link to this 
heading">¶</a></h4>
+<section id="id222">
+<h4>Example<a class="headerlink" href="#id222" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="o">&gt;</span> <span 
class="n">select</span> <span class="n">arrow_typeof</span><span 
class="p">(</span><span class="s1">&#39;foo&#39;</span><span 
class="p">),</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="o">|</span> <span class="n">arrow_typeof</span><span 
class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span 
class="s2">&quot;foo&quot;</span><span class="p">))</span> <span 
class="o">|</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="o">|</span>


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

(datafusion) branch asf-site updated: Publish built docs triggered by f9ef488aecca9a445a5110079fb2f295c80a8850

Reply via email to