http://www.postgresql.org/docs/8.1/static/indexes-types.html Hash indexes can only handle simple equality comparisons. The query planner will consider using a hash index whenever an indexed column is involved in a comparison using the = operator. The following command is used to create a hash index: CREATE INDEX name ON table USING hash (column);
