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.
Bu egzersiz
Functions for Manipulating Data in PostgreSQL
kursunun bir parçasıdırEgzersiz talimatları
- Select the film title and description.
- Calculate the similarity between the title and description.
Uygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
-- Select the title and description columns
SELECT
___,
___,
-- Calculate the similarity
___(___, ___)
FROM
film