Skip to content

Instantly share code, notes, and snippets.

@osiro

osiro/gist:843b391b81f9ca0ecfd3

Created May 22, 2014 07:59
Show Gist options
  • Save osiro/843b391b81f9ca0ecfd3 to your computer and use it in GitHub Desktop.
Save osiro/843b391b81f9ca0ecfd3 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
CREATE INDEX
index_project_tsearch_title_description ON projects
USING gin((
to_tsvector('english'::regconfig, COALESCE((title)::text, ''::text)) ||
to_tsvector('english'::regconfig, COALESCE((description)::text, ''::text))
));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment