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 fdf9b54ef7 Publish built docs triggered by
1f06308037426c46d1a9c4c2d3a8f335c4ad26d1
fdf9b54ef7 is described below
commit fdf9b54ef7ccf71b8a4fec4b066b6c7a8da3b268
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Thu Sep 12 15:24:35 2024 +0000
Publish built docs triggered by 1f06308037426c46d1a9c4c2d3a8f335c4ad26d1
---
_sources/user-guide/sql/scalar_functions.md.txt | 17 +++++++++--------
searchindex.js | 2 +-
user-guide/sql/scalar_functions.html | 17 +++++++++--------
3 files changed, 19 insertions(+), 17 deletions(-)
diff --git a/_sources/user-guide/sql/scalar_functions.md.txt
b/_sources/user-guide/sql/scalar_functions.md.txt
index 14852935dc..6a2181b8db 100644
--- a/_sources/user-guide/sql/scalar_functions.md.txt
+++ b/_sources/user-guide/sql/scalar_functions.md.txt
@@ -3223,9 +3223,9 @@ generate_series(start, stop, step)
#### Arguments
-- **start**: start of the range
-- **end**: end of the range (included)
-- **step**: increase by step (can not be 0)
+- **start**: start of the series. Ints, timestamps, dates or string types that
can be coerced to Date32 are supported.
+- **end**: end of the series (included). Type must be the same as start.
+- **step**: increase by step (can not be 0). Steps less than a day are
supported only for timestamp ranges.
#### Example
@@ -3516,7 +3516,7 @@ The range start..end contains all values with start <= x
< end. It is empty if s
Step can not be 0 (then the range will be nonsense.).
-Note that when the required range is a number, it accepts (stop), (start,
stop), and (start, stop, step) as parameters, but when the required range is a
date, it must be 3 non-NULL parameters.
+Note that when the required range is a number, it accepts (stop), (start,
stop), and (start, stop, step) as parameters, but when the required range is a
date or timestamp, it must be 3 non-NULL parameters.
For example,
```
@@ -3527,10 +3527,11 @@ SELECT range(1,5,1);
are allowed in number ranges
-but in date ranges, only
+but in date and timestamp ranges, only
```
SELECT range(DATE '1992-09-01', DATE '1993-03-01', INTERVAL '1' MONTH);
+SELECT range(TIMESTAMP '1992-09-01', TIMESTAMP '1993-03-01', INTERVAL '1'
MONTH);
```
is allowed, and
@@ -3545,9 +3546,9 @@ are not allowed
#### Arguments
-- **start**: start of the range
-- **end**: end of the range (not included)
-- **step**: increase by step (can not be 0)
+- **start**: start of the range. Ints, timestamps, dates or string types that
can be coerced to Date32 are supported.
+- **end**: end of the range (not included). Type must be the same as start.
+- **step**: increase by step (can not be 0). Steps less than a day are
supported only for timestamp ranges.
#### Aliases
diff --git a/searchindex.js b/searchindex.js
index 5f6269a93f..a72450294e 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"alltitles": {"!=": [[45, "op-neq"]], "!~": [[45,
"op-re-not-match"]], "!~*": [[45, "op-re-not-match-i"]], "!~~": [[45, "id18"]],
"!~~*": [[45, "id19"]], "#": [[45, "op-bit-xor"]], "%": [[45, "op-modulo"]],
"&": [[45, "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"]], "*":
[[45, "op-multiply"]], "+": [[45, "op-plus"]], "-": [[45, "op-minus"]], "/":
[[4 [...]
\ No newline at end of file
+Search.setIndex({"alltitles": {"!=": [[45, "op-neq"]], "!~": [[45,
"op-re-not-match"]], "!~*": [[45, "op-re-not-match-i"]], "!~~": [[45, "id18"]],
"!~~*": [[45, "id19"]], "#": [[45, "op-bit-xor"]], "%": [[45, "op-modulo"]],
"&": [[45, "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"]], "*":
[[45, "op-multiply"]], "+": [[45, "op-plus"]], "-": [[45, "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 f52fa45a29..cf84e48c03 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -7445,9 +7445,9 @@ Can be a constant, column, or function, and any
combination of array operators.<
<section id="id208">
<h4>Arguments<a class="headerlink" href="#id208" 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>
+<li><p><strong>start</strong>: start of the series. Ints, timestamps, dates or
string types that can be coerced to Date32 are supported.</p></li>
+<li><p><strong>end</strong>: end of the series (included). Type must be the
same as start.</p></li>
+<li><p><strong>step</strong>: increase by step (can not be 0). Steps less than
a day are supported only for timestamp ranges.</p></li>
</ul>
</section>
<section id="id209">
@@ -7744,7 +7744,7 @@ Can be a constant, column, or function, and any
combination of array operators.<
<p>Returns an Arrow array between start and stop with step. <code
class="docutils literal notranslate"><span class="pre">SELECT</span> <span
class="pre">range(2,</span> <span class="pre">10,</span> <span
class="pre">3)</span> <span class="pre">-></span> <span
class="pre">[2,</span> <span class="pre">5,</span> <span
class="pre">8]</span></code> or <code class="docutils literal
notranslate"><span class="pre">SELECT</span> <span
class="pre">range(DATE</span> <span class="pre">'1992-09-01 [...]
<p>The range start..end contains all values with start <= x < end. It is
empty if start >= end.</p>
<p>Step can not be 0 (then the range will be nonsense.).</p>
-<p>Note that when the required range is a number, it accepts (stop), (start,
stop), and (start, stop, step) as parameters, but when the required range is a
date, it must be 3 non-NULL parameters.
+<p>Note that when the required range is a number, it accepts (stop), (start,
stop), and (start, stop, step) as parameters, but when the required range is a
date or timestamp, it must be 3 non-NULL parameters.
For example,</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">SELECT</span> <span
class="nb">range</span><span class="p">(</span><span class="mi">3</span><span
class="p">);</span>
<span class="n">SELECT</span> <span class="nb">range</span><span
class="p">(</span><span class="mi">1</span><span class="p">,</span><span
class="mi">5</span><span class="p">);</span>
@@ -7752,8 +7752,9 @@ For example,</p>
</pre></div>
</div>
<p>are allowed in number ranges</p>
-<p>but in date ranges, only</p>
+<p>but in date and timestamp ranges, only</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">SELECT</span> <span
class="nb">range</span><span class="p">(</span><span class="n">DATE</span>
<span class="s1">'1992-09-01'</span><span class="p">,</span> <span
class="n">DATE</span> <span class="s1">'1993-03-01'</span><span
class="p">,</span> <span class="n">INTERVAL</span> <span
class="s1">'1'</span> <span class="n">MONTH</span><span
class="p">);</span>
+<span class="n">SELECT</span> <span class="nb">range</span><span
class="p">(</span><span class="n">TIMESTAMP</span> <span
class="s1">'1992-09-01'</span><span class="p">,</span> <span
class="n">TIMESTAMP</span> <span class="s1">'1993-03-01'</span><span
class="p">,</span> <span class="n">INTERVAL</span> <span
class="s1">'1'</span> <span class="n">MONTH</span><span
class="p">);</span>
</pre></div>
</div>
<p>is allowed, and</p>
@@ -7766,9 +7767,9 @@ For example,</p>
<section id="id217">
<h4>Arguments<a class="headerlink" href="#id217" 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>
+<li><p><strong>start</strong>: start of the range. Ints, timestamps, dates or
string types that can be coerced to Date32 are supported.</p></li>
+<li><p><strong>end</strong>: end of the range (not included). Type must be the
same as start.</p></li>
+<li><p><strong>step</strong>: increase by step (can not be 0). Steps less than
a day are supported only for timestamp ranges.</p></li>
</ul>
</section>
<section id="id218">
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
