| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Daniel J(dot) Summers" <daniel(at)djs-consulting(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: "like" and index |
| Date: | 2009-02-26 00:31:25 |
| Message-ID: | 7549.1235608285@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
"Daniel J. Summers" <daniel(at)djs-consulting(dot)com> writes:
> MySQL will only use it if the wildcard isn't in the front (1) and
> requires the MATCH keyword to search full-text indexes (2), Oracle
> requires special "full-text" indexes to be able to use for LIKE (3)
> (actually dealt with that at work a few months back), SQL Server only
> uses it under certain conditions (4), and even PostgreSQL (the great
> subject of this mailing list) doesn't do it with a standard index (5) -
> you've got to use a special operator class.
Only if you're using a non-C locale.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ashish Karalkar | 2009-02-26 05:11:29 | Re: Replicating between different Slony versions? |
| Previous Message | Daniel J. Summers | 2009-02-26 00:03:31 | Re: "like" and index |