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
6. The || operator vs the CONCAT() function
Simple text functions
Modifying strings
Summary

Instruction

Great! You know two ways to concatenate values: the || operator and the CONCAT() function. What is the difference between them?

Think back to using the || operator. When there was a NULL value in one of the joining columns, what was returned? A NULL.

The CONCAT() function converts NULL to an empty string. Let's see this in an example. Remember, if any of the columns you work with can contain a NULL, use the CONCAT() function and not the || operator.

Exercise

In this exercise, just look at the result.

You see Vacum2010 as the product name, although there was a NULL value in the type column.