Index on substring

[Håvard Wahl Kongsgård <haavard.kongsgaard@xxxxxxxxx>]

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)?

--
Hård Wahl Kongsgå

http://havard.security-review.net/