Text & patterns
Scalar
overlay()
Replaces a substring of string starting at character start with replacement. If count is not specified, it defaults to the length of replacement. Note that a start value of 1 refers to the first character of the string.
Reference: Haybarn WASM 2.0.0-rc12
Arguments & returns
2 overloadsoverlay(string, replacement, start)
Scalar
| Overload link | string | replacement | start |
Returns |
|---|---|---|---|---|
| #01 | VARCHAR | VARCHAR | BIGINT |
VARCHAR |
overlay(string, replacement, start, count)
Scalar
| Overload link | string | replacement | start | count |
Returns |
|---|---|---|---|---|---|
| #02 | VARCHAR | VARCHAR | BIGINT | BIGINT |
VARCHAR |
Example
1 more ↓Haybarn WASM 2.0.0-rc12 · In your browser
Engine example · Run to view results.
More examples
Haybarn WASM 2.0.0-rc12 · In your browser
Engine example · Run to view results.