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 5655fa18dd Publish built docs triggered by
ec7c9ab0af56917470c83694e9fb0efbd76c7d91
5655fa18dd is described below
commit 5655fa18dd9e60301e9c62f97e5dd2308d5eb6e2
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Mon Mar 23 16:05:44 2026 +0000
Publish built docs triggered by ec7c9ab0af56917470c83694e9fb0efbd76c7d91
---
_sources/user-guide/sql/scalar_functions.md.txt | 2 +-
searchindex.js | 2 +-
user-guide/sql/scalar_functions.html | 2 +-
3 files changed, 3 insertions(+), 3 deletions(-)
diff --git a/_sources/user-guide/sql/scalar_functions.md.txt
b/_sources/user-guide/sql/scalar_functions.md.txt
index 98a6d63425..918bae0f7d 100644
--- a/_sources/user-guide/sql/scalar_functions.md.txt
+++ b/_sources/user-guide/sql/scalar_functions.md.txt
@@ -1974,7 +1974,7 @@ substr(str, start_pos[, length])
#### Arguments
- **str**: String expression to operate on. Can be a constant, column, or
function, and any combination of operators.
-- **start_pos**: Character position to start the substring at. The first
character in the string has a position of 1.
+- **start_pos**: Character position to start the substring at. The first
character in the string has a position of 1. If the start position is less than
1, it is treated as if it is before the start of the string and the (absolute)
number of characters before position 1 is subtracted from `length` (if given).
For example, `substr('abc', -3, 6)` returns `'ab'`.
- **length**: Number of characters to extract. If not specified, returns the
rest of the string after the start position.
#### Example
diff --git a/searchindex.js b/searchindex.js
index c13efc4f2f..862c841e15 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"alltitles":{"!=":[[72,"op-neq"]],"!~":[[72,"op-re-not-match"]],"!~*":[[72,"op-re-not-match-i"]],"!~~":[[72,"id19"]],"!~~*":[[72,"id20"]],"#":[[72,"op-bit-xor"]],"%":[[72,"op-modulo"]],"&":[[72,"op-bit-and"]],"(relation,
name) tuples in logical fields and logical columns are
unique":[[14,"relation-name-tuples-in-logical-fields-and-logical-columns-are-unique"]],"*":[[72,"op-multiply"]],"+":[[72,"op-plus"]],"-":[[72,"op-minus"]],"/":[[72,"op-divide"]],"1.
Array Literal Con [...]
\ No newline at end of file
+Search.setIndex({"alltitles":{"!=":[[72,"op-neq"]],"!~":[[72,"op-re-not-match"]],"!~*":[[72,"op-re-not-match-i"]],"!~~":[[72,"id19"]],"!~~*":[[72,"id20"]],"#":[[72,"op-bit-xor"]],"%":[[72,"op-modulo"]],"&":[[72,"op-bit-and"]],"(relation,
name) tuples in logical fields and logical columns are
unique":[[14,"relation-name-tuples-in-logical-fields-and-logical-columns-are-unique"]],"*":[[72,"op-multiply"]],"+":[[72,"op-plus"]],"-":[[72,"op-minus"]],"/":[[72,"op-divide"]],"1.
Array Literal Con [...]
\ No newline at end of file
diff --git a/user-guide/sql/scalar_functions.html
b/user-guide/sql/scalar_functions.html
index 13f934502b..bdb2c66044 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -2456,7 +2456,7 @@ This can be used to perform the inverse operation of <a
class="reference interna
<h4>Arguments<a class="headerlink" href="#id144" title="Link to this
heading">#</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
-<li><p><strong>start_pos</strong>: Character position to start the substring
at. The first character in the string has a position of 1.</p></li>
+<li><p><strong>start_pos</strong>: Character position to start the substring
at. The first character in the string has a position of 1. If the start
position is less than 1, it is treated as if it is before the start of the
string and the (absolute) number of characters before position 1 is subtracted
from <code class="docutils literal notranslate"><span
class="pre">length</span></code> (if given). For example, <code class="docutils
literal notranslate"><span class="pre">substr('abc',</s [...]
<li><p><strong>length</strong>: Number of characters to extract. If not
specified, returns the rest of the string after the start position.</p></li>
</ul>
</section>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
