Re: Partial match in GIN

From: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Teodor Sigaev <teodor(at)sigaev(dot)ru>, Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Partial match in GIN
Date: 2008-04-09 07:34:37
Message-ID: 47FC718D.5000501@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Alvaro Herrera wrote:
> Well, LIKE %foo% is supposed to match foo unanchored, but with a btree
> (or two btrees) you can only get 'foo' anchored to either end of the
> string (or both).

Ah, true.

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Heikki Linnakangas 2008-04-09 08:25:06 Re: EXPLAIN progress info
Previous Message Andrew Chernow 2008-04-09 05:56:14 Re: [PATCHES] libpq type system 0.9a