-- add full search capabilities for description (threw in genre too)
ALTER TABLE music_sessions ADD COLUMN description_tsv tsvector;
CREATE TRIGGER tsvectorupdate BEFORE INSERT OR UPDATE
ON music_sessions FOR EACH ROW EXECUTE PROCEDURE
tsvector_update_trigger(description_tsv, 'public.jamenglish', description);
CREATE INDEX music_sessions_description_tsv_index ON music_sessions USING gin(description_tsv);

-- prime the pump
UPDATE music_sessions set description = description;