1. Learn
    2. /
  2. Courses
    3. /
  3. Functions for Manipulating Data in PostgreSQL

Exercise

Measuring similarity between two strings

Now that you have enabled the fuzzystrmatch and pg_trgm extensions you can begin to explore their capabilities. First, we will measure the similarity between the title and description from the film table of the Sakila database.

Instructions

100 XP
  • Select the film title and description.
  • Calculate the similarity between the title and description.