Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Common Functions in PostgreSQL

Introduction
Concatenation
Simple text functions
11. The LTRIM() and RTRIM() functions
Modifying strings
Summary

Instruction

Great! Let's look at functions that remove leading or trailing spaces from a string.

One of these is LTRIM(). It removes the leading (left) spaces from a string.

SELECT LTRIM(' Sophie ');

This query returns 'Sophie '. The leading space was removed.

The RTRIM() function removes the trailing (right) spaces from a string. It works in a similar way:

SELECT RTRIM(' Sophie ');

This returns ' Sophie'. There is a leading space, but no trailing space.

Exercise

Some of the item names in the item table have leading spaces. Show two columns:

  • The item name.
    Prefix the value with 'No trim:' to see the leading spaces.
    Name the column before_ltrim.
  • The item name without leading spaces.
    Prefix the value with 'Trim:' to make sure the spaces have been removed.
    Name the column after_ltrim.

To add prefixes, use the concatenation operator.

Stuck? Here's a hint!

Use LTRIM(name) to remove leading spaces from the item names. Don't put any spaces at the end of the prefixes.