| From: | "David Olbersen" <DOlbersen(at)stbernard(dot)com> |
|---|---|
| To: | <pgsql-sql(at)postgresql(dot)org> |
| Cc: | <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Help with LIKE |
| Date: | 2003-03-20 23:19:13 |
| Message-ID: | E7E213858379814A9AE48CA6754F5ECB0D6C32@mail01.stbernard.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance pgsql-sql |
Josh,
> That's what's called an "unanchored text search". That kind
> of query cannot be indexed using a regular index.
Duh, should have tried the anchors to get what I wanted...
> What you need is called "Full Text Indexing" or "Full Text
> Search". Check
> out two resources:
This isn't actually what I was looking for, the anchor works better (only 5.87 now!)
Thanks for the reminder!
--------------------------
David Olbersen
iGuard Engineer
11415 West Bernardo Court
San Diego, CA 92127
1-858-676-2277 x2152
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Olbersen | 2003-03-20 23:35:39 | Re: Help with LIKE |
| Previous Message | Florian Weimer | 2003-03-20 23:01:18 | Re: postgresql meltdown on PlanetMath.org |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Abdul Wahab Dahalan | 2003-03-21 02:47:14 | What this parser mean? |
| Previous Message | Mario Alberto Soto Cordones | 2003-03-20 22:25:58 | FUNCTIONS PROBLEM |