update_imsdb_search_tables.sql

-- search vectors column and create index
alter table movie_scripts add "document_vectors" tsvector;
create index idx_fts_doc_vector on movie_scripts using gin(document_vectors);

-- update the search vectors column with script
update
	movie_scripts
set
	document_vectors = (to_tsvector('english', names) || to_tsvector('english', script));

-- basic querying the scripts based on relevancy
select
	links
	, names
	, ts_headline('english', script, websearch_to_tsquery('english', 'Days of Summer'))
	, ts_rank_cd(document_vectors, query) as relevance
from movie_scripts, websearch_to_tsquery('english', 'Days of Summer') query
where document_vectors @@ query
limit 5;