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 b61f895fa Revert "Document the CONCAT_DELIM function."
b61f895fa is described below
commit b61f895fab4021d4f6185e6701729c939d0bddf5
Author: James Turton <[email protected]>
AuthorDate: Wed May 11 19:22:32 2022 +0200
Revert "Document the CONCAT_DELIM function."
This reverts commit a4ff3a36390247652dee9586cf6101ddb04424ee.
---
.../sql-functions/040-string-manipulation.md | 21 ---------------------
1 file changed, 21 deletions(-)
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 7f38af40d..454a736dd 100644
--- a/_docs/en/sql-reference/sql-functions/040-string-manipulation.md
+++ b/_docs/en/sql-reference/sql-functions/040-string-manipulation.md
@@ -11,7 +11,6 @@ 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 |
@@ -116,26 +115,6 @@ 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.