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 vote147 views1 answer
Oracle sql date summer time
SQL
16 votes152 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
11 votes149 views2 answers
Safe mode off mysql
SQL
0 vote156 views1 answer
Mysql persistence.xml
SQL
0 vote140 views1 answer
How should I pass a table name into a stored proc?
SQL
0 vote148 views2 answers
Greater than sql server
SQL
57 votes325 views5 answers
How to create a new user in postgresql
SQL
1 vote137 views1 answer
Get rows affected mysql python
SQL
0 vote100 views1 answer
Finish transaction sql
SQL
0 vote136 views1 answer
Java sql insert return id
SQL