This is an automated email from the ASF dual-hosted git repository.
dzamo pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/drill-site.git
The following commit(s) were added to refs/heads/master by this push:
new a4ff3a363 Document the CONCAT_DELIM function.
a4ff3a363 is described below
commit a4ff3a36390247652dee9586cf6101ddb04424ee
Author: James Turton <[email protected]>
AuthorDate: Wed May 11 15:31:49 2022 +0200
Document the CONCAT_DELIM function.
---
.../sql-functions/040-string-manipulation.md | 21 +++++++++++++++++++++
1 file changed, 21 insertions(+)
diff --git a/_docs/en/sql-reference/sql-functions/040-string-manipulation.md
b/_docs/en/sql-reference/sql-functions/040-string-manipulation.md
index 454a736dd..7f38af40d 100644
--- a/_docs/en/sql-reference/sql-functions/040-string-manipulation.md
+++ b/_docs/en/sql-reference/sql-functions/040-string-manipulation.md
@@ -11,6 +11,7 @@ You can use the following string functions in Drill queries:
| [BYTE_SUBSTR]({{ site.baseurl }}/docs/string-manipulation/#byte_substr)
| BINARY or VARCHAR |
| [CHAR_LENGTH]({{ site.baseurl }}/docs/string-manipulation/#char_length)
| INTEGER |
| [CONCAT]({{ site.baseurl }}/docs/string-manipulation/#concat)
| VARCHAR |
+| [CONCAT_DELIM]({{ site.baseurl }}/docs/string-manipulation/#concat_delim)
| VARCHAR |
| [ILIKE]({{ site.baseurl }}/docs/string-manipulation/#ilike)
| BOOLEAN |
| [INITCAP]({{ site.baseurl }}/docs/string-manipulation/#initcap)
| VARCHAR |
| [LENGTH]({{ site.baseurl }}/docs/string-manipulation/#length)
| INTEGER |
@@ -115,6 +116,26 @@ Concatenates arguments.
Alternatively, you can use the [string concatenation operation]({{
site.baseurl }}/docs/operators/#string-concatenate-operator) to concatenate
strings.
+## CONCAT_DELIM
+Concatenates arguments inserting the provided delimiter between each pair.
Null arguments are eliminated.
+
+### CONCAT_DELIM Syntax
+
+ CONCAT_DELIM(delimiter [, string [, ...] )
+
+### CONCAT_DELIM Example
+
+ SELECT CONCAT_DELIM('&', 'cat', null, 'mat') FROM (VALUES(1));
+
+ |-------------------|
+ | EXPR$0 |
+ |-------------------|
+ | cat&mat |
+ |-------------------|
+ 1 row selected (0.134 seconds)
+
+Alternatively, you can use the [string concatenation operation]({{
site.baseurl }}/docs/operators/#string-concatenate-operator) to concatenate
strings.
+
## ILIKE
Performs a case-insensitive comparison of the input string with a pattern and
returns
true in the case of a match.
