Jump to: navigation, search

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)

Related Links


Navigation
Web
SQL
MISC
References