Module expr_fn

Functions§

ascii: Returns the ASCII code point of the first character of string.
char: Returns the ASCII character having the binary equivalent to col. If col is larger than 256 the result is equivalent to char(col % 256).
concat: Concatenates multiple input strings into a single string. Returns NULL if any input is NULL.
elt: Returns the n-th input (1-indexed), e.g. returns 2nd input when n is 2. The function returns NULL if the index is 0 or exceeds the length of the array.
format_string: Returns a formatted string from printf-style format strings.
ilike: Returns true if str matches pattern (case insensitive).
length: Returns the character length of string data or number of bytes of binary data. The length of string data includes the trailing spaces. The length of binary data includes binary zeros.
like: Returns true if str matches pattern (case sensitive).
luhn_check: Returns whether the input string of digits is valid according to the Luhn algorithm.