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
3. The slogan table
Concatenation
Simple text functions
Modifying strings
Summary

Instruction

Finally, let's look at the third table.

Exercise

Select all data from the slogan table. For each record, we have:

  • id – an identifier.
  • item_id – an ID of an advertised product.
  • type – the best medium for the slogan (e.g., TV, Internet, or newspapers).
  • text – the slogan itself.
  • copywriter_id – the ID of the copywriter who wrote that slogan.