akp geek <akpgeek@gmail.com> writes:
> What we do with the text that I have mentioned is, we have
> search functionality on the text. The user enters some keywords and then the
> application should be able to search for all the text that matches the key
> word.
Well, a btree index on the entire string is approximately useless for
that anyway. Look into the text search functionality.
regards, tom lane
