MapofLife/MOL — Issue #51: Search index
Author: eightysteele
Created: 2012-01-30 03:34:25+00:00
State: open

Our search index rides on `scientificname` like this:

```sql
CREATE INDEX sn_idx ON points USING gin(to_tsvector('english', scientificname))
CREATE INDEX sn_idx ON polygons USING gin(to_tsvector('english', scientificname))
```

Given a scientific name like `Lagenorhynchus cruciger`, we can search for it on `Lagenorhynchus` but not on the full scientific name. We need to be able to search on the full scientific name.

More info:

http://www.postgresql.org/docs/9.1/static/textsearch.html