RTRIM

Syntax

RTRIM(str [, char_set])

Overview

RTRIM is a function that removes all characters contained in char_set from the right side of str.

Parameter

Parameter	Description
str	Arbitrary operation that returns a string.
char_set	Arbitrary operation that returns a string. If the value of the char_set parameter is not specified, the default value is one space character.

Example

SELECT RTRIM('ABCDEFGHIJKLMNOP', 'LMNOP');
    rtrim    
-------------
 ABCDEFGHIJK
 (1 row)