Hi there,
I am creating functionality where there are blocks of text that are
being stored in the DB and that need to be searched for. No like or
pattern matching, just a plain old WHERE clause. Obviously, hash indexes
would be best here, however I've been warned away from PG's hash
implementation. Would it be better to manually create a column storing
the hashes (maintained with a CHECK (md5(textcol) = hashcol) type
constraint) and generate the hashes in the app?
- Naz.