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 708d75697b Publish built docs triggered by
383f279982777e5a4306f0072403bb822158b3fc
708d75697b is described below
commit 708d75697bc413dbf2db124b0451c7531142b13c
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Sun Dec 29 19:26:30 2024 +0000
Publish built docs triggered by 383f279982777e5a4306f0072403bb822158b3fc
---
_sources/user-guide/sql/scalar_functions.md.txt | 24 ++++++++----------------
user-guide/sql/scalar_functions.html | 24 ++++++++----------------
2 files changed, 16 insertions(+), 32 deletions(-)
diff --git a/_sources/user-guide/sql/scalar_functions.md.txt
b/_sources/user-guide/sql/scalar_functions.md.txt
index 4cf5ff4b71..f17e7189a9 100644
--- a/_sources/user-guide/sql/scalar_functions.md.txt
+++ b/_sources/user-guide/sql/scalar_functions.md.txt
@@ -3122,34 +3122,26 @@ array_position(array, element, index)
### `array_positions`
-Returns the position of the first occurrence of the specified element in the
array.
+Searches for an element in the array, returns all occurrences.
```
-array_position(array, element)
-array_position(array, element, index)
+array_positions(array, element)
```
#### Arguments
- **array**: Array expression. Can be a constant, column, or function, and any
combination of array operators.
- **element**: Element to search for position in the array.
-- **index**: Index at which to start searching.
#### Example
```sql
-> select array_position([1, 2, 2, 3, 1, 4], 2);
-+----------------------------------------------+
-| array_position(List([1,2,2,3,1,4]),Int64(2)) |
-+----------------------------------------------+
-| 2 |
-+----------------------------------------------+
-> select array_position([1, 2, 2, 3, 1, 4], 2, 3);
-+----------------------------------------------------+
-| array_position(List([1,2,2,3,1,4]),Int64(2), Int64(3)) |
-+----------------------------------------------------+
-| 3 |
-+----------------------------------------------------+
+> select array_positions([1, 2, 2, 3, 1, 4], 2);
++-----------------------------------------------+
+| array_positions(List([1,2,2,3,1,4]),Int64(2)) |
++-----------------------------------------------+
+| [2, 3] |
++-----------------------------------------------+
```
#### Aliases
diff --git a/user-guide/sql/scalar_functions.html
b/user-guide/sql/scalar_functions.html
index 7a17721d06..4566406abb 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -7736,9 +7736,8 @@ an error will be returned.</p></li>
</section>
<section id="array-positions">
<h3><code class="docutils literal notranslate"><span
class="pre">array_positions</span></code><a class="headerlink"
href="#array-positions" title="Link to this heading">¶</a></h3>
-<p>Returns the position of the first occurrence of the specified element in
the array.</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><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">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>
+<p>Searches for an element in the array, returns all occurrences.</p>
+<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="id213">
@@ -7746,23 +7745,16 @@ an error will be returned.</p></li>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or
function, and any combination of array operators.</p></li>
<li><p><strong>element</strong>: Element to search for position in the
array.</p></li>
-<li><p><strong>index</strong>: Index at which to start searching.</p></li>
</ul>
</section>
<section id="id214">
<h4>Example<a class="headerlink" href="#id214" title="Link to this
heading">¶</a></h4>
-<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">select</span><span class="w"> </span><span
class="n">array_position</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="w"> </span><span
class="mi">2</span><span class="p">,</span><span class="w"> </span><span
class="mi">2</span><span class="p">,</span><span class="w"> </span><span
class="mi">3</span><s [...]
-<span class="o">+</span><span
class="c1">----------------------------------------------+</span>
-<span class="o">|</span><span class="w"> </span><span
class="n">array_position</span><span class="p">(</span><span
class="n">List</span><span class="p">([</span><span class="mi">1</span><span
class="p">,</span><span class="mi">2</span><span class="p">,</span><span
class="mi">2</span><span class="p">,</span><span class="mi">3</span><span
class="p">,</span><span class="mi">1</span><span class="p">,</span><span
class="mi">4</span><span class="p">]),</span><span class="n">Int64</span><span
c [...]
-<span class="o">+</span><span
class="c1">----------------------------------------------+</span>
-<span class="o">|</span><span class="w"> </span><span class="mi">2</span><span
class="w"> </span><span
class="o">|</span>
-<span class="o">+</span><span
class="c1">----------------------------------------------+</span>
-<span class="o">></span><span class="w"> </span><span
class="k">select</span><span class="w"> </span><span
class="n">array_position</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="w"> </span><span
class="mi">2</span><span class="p">,</span><span class="w"> </span><span
class="mi">2</span><span class="p">,</span><span class="w"> </span><span
class="mi">3</span><span class="p">,</span><span class="w"> </span><span
class="mi">1</span><span cla [...]
-<span class="o">+</span><span
class="c1">----------------------------------------------------+</span>
-<span class="o">|</span><span class="w"> </span><span
class="n">array_position</span><span class="p">(</span><span
class="n">List</span><span class="p">([</span><span class="mi">1</span><span
class="p">,</span><span class="mi">2</span><span class="p">,</span><span
class="mi">2</span><span class="p">,</span><span class="mi">3</span><span
class="p">,</span><span class="mi">1</span><span class="p">,</span><span
class="mi">4</span><span class="p">]),</span><span class="n">Int64</span><span
c [...]
-<span class="o">+</span><span
class="c1">----------------------------------------------------+</span>
-<span class="o">|</span><span class="w"> </span><span class="mi">3</span><span
class="w"> </span><span
class="o">|</span>
-<span class="o">+</span><span
class="c1">----------------------------------------------------+</span>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">select</span><span class="w"> </span><span
class="n">array_positions</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="w"> </span><span
class="mi">2</span><span class="p">,</span><span class="w"> </span><span
class="mi">2</span><span class="p">,</span><span class="w"> </span><span
class="mi">3</span>< [...]
+<span class="o">+</span><span
class="c1">-----------------------------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span
class="n">array_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
[...]
+<span class="o">+</span><span
class="c1">-----------------------------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span class="p">[</span><span
class="mi">2</span><span class="p">,</span><span class="w"> </span><span
class="mi">3</span><span class="p">]</span><span class="w">
</span><span class="o">|</span>
+<span class="o">+</span><span
class="c1">-----------------------------------------------+</span>
</pre></div>
</div>
</section>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
