Module expr_fn

Functions

• ascii
  Returns the numeric code of the first character of the argument.
• bit_length
  Returns the number of bits in the string
• btrim
  Removes all characters, spaces by default, from both sides of a string
• chr
  Converts the Unicode code point to a UTF8 character
• concat
  Concatenates the text representations of all the arguments. NULL arguments are ignored
• concat_ws
  Concatenates all but the first argument, with separators. The first argument is used as the separator string, and should not be NULL. Other NULL arguments are ignored.
• contains
  Return true if search_string is found within string. treated it like a reglike
• ends_with
  Returns true if the string ends with the suffix, false otherwise.
• initcap
  Converts the first letter of each word in string in uppercase and the remaining characters in lowercase
• levenshtein
  Returns the Levenshtein distance between the two given strings
• lower
  Converts a string to lowercase.
• ltrim
  Removes all characters, spaces by default, from the beginning of a string
• octet_length
  returns the number of bytes of a string
• overlay
  replace the substring of string that starts at the start’th character and extends for count characters with new substring
• repeat
  Repeats the string to n times
• replace
  Replaces all occurrences of from with to in the string
• rtrim
  Removes all characters, spaces by default, from the end of a string
• split_part
  Splits a string based on a delimiter and picks out the desired field based on the index.
• starts_with
  Returns true if string starts with prefix.
• to_hex
  Converts an integer to a hexadecimal string.
• trim
  Removes all characters, spaces by default, from both sides of a string
• upper
  Converts a string to uppercase.
• uuid
  returns uuid v4 as a string value