PostgreSQL: ltrim Function
This PostgreSQL tutorial explains how to use the PostgreSQL ltrim function with syntax and examples.
Description
The PostgreSQL ltrim function removes all specified characters from the left-hand side of a string.
Syntax
The syntax for the ltrim function in PostgreSQL is:
ltrim( string, trim_character )
Parameters or Arguments
- string
- The string to trim from the left-hand side.
- trim_character
- The set of characters that will be removed from the left-hand side of string. If this parameter is omitted, the ltrim function will remove space characters from the left-hand side of string.
Applies To
The ltrim function can be used in the following versions of PostgreSQL:
- PostgreSQL 9.4, PostgreSQL 9.3, PostgreSQL 9.2, PostgreSQL 9.1, PostgreSQL 9.0, PostgreSQL 8.4
Example
Let's look at some PostgreSQL ltrim function examples and explore how to use the ltrim function in PostgreSQL.
For example:
(Please note that for each of the example results below, we have included single quotes around the result to demonstrate what the ltrim function returns in PostgreSQL. If you ran these commands yourself, you would not see the single quotes in the result):
postgres=# SELECT ltrim(' techonthenet.com ', ' '); ltrim ---------------------- 'techonthenet.com ' (1 row) postgres=# SELECT ltrim(' Tech on the net '); ltrim ---------------------------- 'Tech on the net ' (1 row) postgres=# SELECT ltrim(' techonthenet.com'); ltrim -------------------- 'techonthenet.com' (1 row) postgres=# SELECT ltrim('000123', '0'); ltrim ------- '123' (1 row)
Advertisements