Chapter1 Full Text Search

space travel

The service will use the prompt to perform a full-text search across movie overviews. The results will appear as follows:

PostgreSQL can filter movies by rank and category before doing the full-text search. For instance, set rank to 7, choose Science Fiction as the category, and repeat the search again:

Here's the SQL query that YugaPlus uses to find the movie recommendations:

SELECT id, title, overview, vote_average, release_date FROM movie 
WHERE vote_average >= :rank 
AND genres @> :category::jsonb 
AND overview_lexemes @@ plainto_tsquery('english', :prompt) 
LIMIT :max_results