Dnia 2003-06-16 21:55, Użytkownik Bruno Wolff III napisał:
> On Mon, Jun 16, 2003 at 21:49:40 +0200,
> Tomasz Myrta <jasiek(at)klaster(dot)net> wrote:
>
>>Hi
>>Recently I was wondering about tables difficult to index. Example -
>>queries with "ilike" where clauses. Without additional contrib modules
>>the only way to search such tables is sequential scan (am I right?)
>
>
> You might be able to use a functional index depending on exactly what your
> search patterns are like.
Probably functional indexes won't be helpful to find _substrings_.
Tomasz