PostgreSQL RTRIM
From w3cyberlearnings
Contents |
Postgresql rtrim
This function removes the trailling space or a specific character. (Remove on the right for any whitespace or character if specifies)
Syntax rtrim
- string is string to remove white space or specific character
- char(optional) is a character to be removed
rtrim(string, char)
Example 1
test2=# SELECT rtrim(' girl '); rtrim ------- girl (1 row) test2=# SELECT rtrim('girleeee','e'); rtrim ------- girl (1 row)