Re: Creating an index-type for LIKE '%value%'

From: Larry Rosenman <ler(at)lerctr(dot)org>
To: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Creating an index-type for LIKE '%value%'
Date: 2005-02-08 13:27:49
Message-ID: Pine.uw2.4.61.0502080727020.29519@lerami.lerctr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 8 Feb 2005, Oleg Bartunov wrote:

> On Mon, 7 Feb 2005, Larry Rosenman wrote:
>
>> Oleg Bartunov wrote:
>
> Larry, I pointed you to pg_trgm module mostly following Martijn's
> suggestions. Now, I see you need another our module - ltree,
> see http://www.sai.msu.su/~megera/postgres/gist/ltree/
> for details.

I maybe dense, but could you give me an example?

I'm not seeing it for some reason :).

Thanks,
LER

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Doug McNaught 2005-02-08 13:41:38 Re: Update command too slow
Previous Message sid tow 2005-02-08 13:15:55 Performance tuning using copy