Postgres trim string

SELECT
	TRIM (
		LEADING
		FROM
			'  PostgreSQL TRIM'
	),
	TRIM (
		TRAILING
		FROM
			'PostgreSQL TRIM   '
	),
	TRIM ('  PostgreSQL TRIM  ');
Code language: SQL (Structured Query Language) (sql)

Source: postgresqltutorial.com

Postgres trim string

LTRIM(string, [character]);
RTRIM(string, [character]);
BTRIM(string, [character]);Code language: SQL (Structured Query Language) (sql)

Source: postgresqltutorial.com

Postgres trim string

SELECT
	TRIM (
		LEADING '0'
		FROM
			CAST (0009100 AS TEXT)
	); -- 9100Code language: SQL (Structured Query Language) (sql)

Source: postgresqltutorial.com

Similar codes

0 vote225 views1 answer
Cahnge column name apex oracle
SQL
1 vote187 views3 answers
Drop unique key constraint in sql server
SQL
0 vote232 views1 answer
Start stop mysql linux
SQL
16 votes184 views1 answer
Mysql mediumint max value
SQL
0 vote171 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
2 votes201 views1 answer
Sql percentage with % rounded down
SQL
0 vote210 views1 answer
Sql server beginning of month
SQL
2 votes176 views1 answer
Sql server case sensitive search
SQL
0 vote179 views1 answer
Set a default value for a column in sqlite
SQL
0 vote340 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL