TRIM, LTRIM, RTRIM variations in PostgreSQL - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the TRIM function do in PostgreSQL?

TRIM removes specified leading and trailing characters (spaces by default) from a string.

beginner

How does LTRIM differ from TRIM?

LTRIM removes specified characters only from the start (left side) of a string.

beginner

What is the purpose of RTRIM in PostgreSQL?

RTRIM removes specified characters only from the end (right side) of a string.

intermediate

How do you remove only the character 'x' from both ends of a string using TRIM?

Use TRIM(BOTH 'x' FROM your_string) to remove 'x' characters from both ends.

intermediate

Can TRIM remove characters other than spaces? How?

Yes, by specifying the characters to remove, e.g., TRIM(BOTH 'abc' FROM string) removes any 'a', 'b', or 'c' from both ends.

Which function removes spaces only from the start of a string in PostgreSQL?

A RTRIM

B TRIM

C LTRIM

D SUBSTR

LTRIM removes characters (spaces by default) from the left (start) side of the string.

What does RTRIM(' hello ') return by default?

A 'hello '

B 'hello'

C ' hello'

D ' hello '

RTRIM removes trailing spaces from the right side, so leading spaces remain.

How to remove all 'x' characters from both ends of 'xxhelloxx'?

A RTRIM('xxhelloxx', 'x')

B LTRIM('xxhelloxx', 'x')

C SUBSTR('xxhelloxx', 3, 5)

D TRIM(BOTH 'x' FROM 'xxhelloxx')

TRIM with BOTH removes specified characters from both ends.

Which function removes characters only from the right side of a string?

A RTRIM

B REPLACE

C TRIM

D LTRIM

RTRIM removes characters from the right (end) side only.

What is the default character removed by TRIM, LTRIM, and RTRIM if none specified?

A Space character

B Newline character

C Tab character

D Comma

By default, these functions remove spaces if no character is specified.

Explain how TRIM, LTRIM, and RTRIM differ in their behavior and usage.

Think about which side of the string each function affects.

Describe how to remove specific characters, like 'x', from the start and end of a string in PostgreSQL.

Focus on the syntax of TRIM with custom characters.