Hi, my database performance badly on substring comparison between two very large tables.
In postgresql 8.4 is it possible to create a index on a substring, or must I create an new field for the substring match ( and then create a new index for that field)?