Searching an ARRAY with @>
The contains operator @> operator is alternative syntax to the ANY function and matches data in an ARRAY using the following syntax.
WHERE array_name @> ARRAY['search text'] :: type[]
So let's practice using this operator in the exercise.
Bu egzersiz
Functions for Manipulating Data in PostgreSQL
kursunun bir parçasıdırEgzersiz talimatları
- Use the contains operator to match the text
Deleted Scenesin thespecial_featurescolumn.
Uygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
SELECT
title,
special_features
FROM film
-- Filter where special_features contains 'Deleted Scenes'
WHERE ___ ___ ARRAY['Deleted Scenes'];