> Is there a way to make queries using the 'like' operator quicker, more
> specifically for queries that look like:
> select name from table where name like '%abc%';
The index-types available in PostgreSQL (BTree, RTree, Hash) do not support this kind of query. I'm not sure wether
PostgreSQL does still support defining custom index-mehtods. I did read similar in an old manual.
Elmar