PostgreSQL LTRIM
From w3cyberlearnings
Contents |
Postgresql ltrim
Remove white space or specific character on the left of a string.
Syntax ltrim
- string is a string to remove white space or specific character
- character(optional) is a character to be removed in the string
ltrim(string, character)
Example 1
test2=# SELECT ltrim(' girl');
ltrim
-------
girl
(1 row)
test2=# SELECT ltrim('xxxgirl','x');
ltrim
-------
girl
(1 row)
