DuroDBMS API
1.7
|
OPERATOR || (s1 string, s2 string) RETURNS string;
The string concatenation operator.
The result of the concatenation of the operands.
OPERATOR strlen (s string) RETURNS integer;
The string length operator.
The length of s, in code points.
OPERATOR strlen_b (s string) RETURNS integer;
The string length operator, returning the number of bytes.
The length of s, in bytes.
OPERATOR substr(s string, start integer, length integer) RETURNS string;
Extracts a substring.
The substring of s with length length starting at position start. length and start are measured in code points, according to the current encoding.
OPERATOR substr_b(s string, start integer, length integer) RETURNS string;
OPERATOR substr_b(s string, start integer) RETURNS string;
Extracts a substring.
The substring of s with length length starting at position start. length and start are measured in bytes. If called with 2 arguments, the substring extends to the end of s.
OPERATOR strfind_b (haystack string, needle string) RETURNS integer;
OPERATOR strfind_b (haystack string, needle string, int pos) RETURNS integer;
Finds the first occurrence of the string needle in the string haystack. If called with 3 arguments, it finds the first occurrence after pos, where pos is a byte offset.
The position of the substring, in bytes, or -1 if the substring has not been found.
OPERATOR starts_with (s string, prefix string) RETURNS boolean;
Tests if string s starts with string prefix.
TRUE if s starts with prefix, FALSE otherwise
OPERATOR like (s string, pattern string) RETURNS boolean;
Pattern matching operator. A period ('.') matches a single character; an asterisk ('*') matches zero or more characters.
TRUE if s matches pattern, FALSE otherwise.
OPERATOR regex_like (s string, pattern string) RETURNS boolean;
The regular expression matching operator.
TRUE if s matches pattern, FALSE otherwise.
OPERATOR format (format string, ...) RETURNS string;
Generates a formatted string in the style of sprintf. The arguments passed after format must be of type string, integer, or float and must match the format argument.
The formatted output string.
OPERATOR lower (s string) RETURNS string;
Returns the string s, converted to lowercase.
The string, converted to lowercase.
OPERATOR upper (s string) RETURNS string;
Returns the string s, converted to uppercase.
The string, converted to uppercase.