| From: | "Julian Scarfe" <julian(at)avbrief(dot)com> |
|---|---|
| To: | "Stephan Szabo" <sszabo(at)megazone23(dot)bigpanda(dot)com> |
| Cc: | <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Indexes with LIKE |
| Date: | 2002-07-13 18:18:18 |
| Message-ID: | 016101c22a99$a9951d80$0500a8c0@Wilbur |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
From: "Stephan Szabo" <sszabo(at)megazone23(dot)bigpanda(dot)com>
> You need to have made the database in C locale in order to get index scans
> from LIKE. I think that's mentioned in the Localization section of the
> admin guide, but I could be remembering that wrong.
Thanks very much Stephan. Indeed it's in Admin Guide 5.1.2. I was using
en_GB, not C.
There is of course no excuse for failing to read every bit of smallprint in
the admin guide before installation :-) but for those lazy unfortunates like
me that don't think to look there to find out what's wrong when indexes
aren't used with LIKE, I've added a DocNote under Pattern Matching.
Julian Scarfe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-07-13 19:27:27 | Re: It is a bug in pred_test()! (Was: [SQL] Please, HELP! Why is the query plan so wrong???) |
| Previous Message | Stephan Szabo | 2002-07-13 15:28:34 | Re: Indexes with LIKE |