danielnewman(at)umich(dot)edu writes:
> When I run the query `select * from hash_issue_table where hash_issue_column
> like '2184';` I get 701 results. When I run the query
> When I run the query `select * from hash_issue_table where hash_issue_column
> = '2184';`, I get 0 results. However, if I drop the hash index and rerun the
> second query, I get the same results.
Sounds like a corrupted hash index to me; which is not terribly surprising
given hash indexes' lack of WAL support. Can you reproduce this after
rebuilding the hash index?
regards, tom lane