diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2011-01-31 21:33:55 -0500 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2011-01-31 21:34:49 -0500 |
| commit | 6e2f3ae8842392c46ccc91a9ce4bba92296890cb (patch) | |
| tree | 5a672b0b9a6f1b5f0d1b264285cfb5a74574e13e /src/backend/utils/adt/arrayfuncs.c | |
| parent | 6238473adb119a5a11061e40e159e8c5187fe492 (diff) | |
| download | postgresql-6e2f3ae8842392c46ccc91a9ce4bba92296890cb.tar.gz postgresql-6e2f3ae8842392c46ccc91a9ce4bba92296890cb.zip | |
Support LIKE and ILIKE index searches via contrib/pg_trgm indexes.
Unlike Btree-based LIKE optimization, this works for non-left-anchored
search patterns. The effectiveness of the search depends on how many
trigrams can be extracted from the pattern. (The worst case, with no
trigrams, degrades to a full-table scan, so this isn't a panacea. But
it can be very useful.)
Alexander Korotkov, reviewed by Jan Urbanski
Diffstat (limited to 'src/backend/utils/adt/arrayfuncs.c')
0 files changed, 0 insertions, 0 deletions