Re: Partial match in GIN - Mailing list 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