Expand description
String expressions
Functions
- Returns the numeric code of the first character of the argument. ascii(‘x’) = 120
- Removes the longest string containing only characters in characters (a space by default) from the start and end of string. btrim(‘xyxtrimyyx’, ‘xyz’) = ‘trim’
- Returns the character with the given code. chr(0) is disallowed because text data types cannot store that character. chr(65) = ‘A’
- Concatenates the text representations of all the arguments. NULL arguments are ignored. concat(‘abcde’, 2, NULL, 22) = ‘abcde222’
- 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. concat_ws(‘,’, ‘abcde’, 2, NULL, 22) = ‘abcde,2,22’
- Converts the first letter of each word to upper case and the rest to lower case. Words are sequences of alphanumeric characters separated by non-alphanumeric characters. initcap(‘hi THOMAS’) = ‘Hi Thomas’
- Converts the string to all lower case. lower(‘TOM’) = ‘tom’
- Removes the longest string containing only characters in characters (a space by default) from the start of string. ltrim(‘zzzytest’, ‘xyz’) = ‘test’
- Repeats string the specified number of times. repeat(‘Pg’, 4) = ‘PgPgPgPg’
- Replaces all occurrences in string of substring from with substring to. replace(‘abcdefabcdef’, ‘cd’, ‘XX’) = ‘abXXefabXXef’
- Removes the longest string containing only characters in characters (a space by default) from the end of string. rtrim(‘testxxzx’, ‘xyz’) = ‘test’
- Splits string at occurrences of delimiter and returns the n’th field (counting from one). split_part(‘abc~@
def@ghi’, ‘@~’, 2) = ‘def’ - Returns true if string starts with prefix. starts_with(‘alphabet’, ‘alph’) = ‘t’
- Converts the number to its equivalent hexadecimal representation. to_hex(2147483647) = ‘7fffffff’
- Converts the string to all upper case. upper(‘tom’) = ‘TOM’
- Prints random (v4) uuid values per row uuid() = ‘a0eebc99-9c0b-4ef8-bb6d-6bb9bd380a11’