LTRIM

Syntax

LTRIM(str [, char_set])

Overview

LTRIM is a function that removes all characters contained in char_set from the left 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 LTRIM('ABCDEFGHIJKLMNOP', 'ABCDEF');
   ltrim    
------------
 GHIJKLMNOP
 (1 row)