EasyString Functions

TRIM, LTRIM, RTRIM: remove whitespace

The query

SQL

SELECT
  TRIM('  hello world  ') AS trimmed,
  LTRIM('  left  ') AS left_trimmed,
  RTRIM('  right  ') AS right_trimmed,
  TRIM(BOTH 'x' FROM 'xxxHelloxxx') AS custom_trim;

Tested against PostgreSQL 16

Note

“TRIM(BOTH/LEADING/TRAILING) can remove specific characters, not just spaces.