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.
Este exercício faz parte do curso
Functions for Manipulating Data in PostgreSQL
Instruções do exercício
- Select the film title and description.
- Calculate the similarity between the title and description.
Exercício interativo prático
Experimente este exercício completando este código de exemplo.
-- Select the title and description columns
SELECT
___,
___,
-- Calculate the similarity
___(___, ___)
FROM
film