> It looks to me like you have an index of type "bpchar" but are searching > with type "text." I find type conversions very limited with "LIKE." > > I would create an index on 'vin_no' using a cast to TEXT. This should work > on both queries.
Not in this case. Just to be sure, I created a new column as text type, created index, analyzed, and searched and got the same behavior. Furthermore, I did this: cpc=# show lc_collate; lc_collate ------------ C (1 row) cpc=# show lc_ctype; lc_ctype ---------- C (1 row) followed by this: C:\postgres\pgsql\src\test\locale>pg_controldata [...] LC_COLLATE: English_United States.1252 LC_CTYPE: English_United States.1252 At this point I'm about 90% sure I've turned up a locale related bug...initdb warned me wrt the locale but psql is still reporting 'C'. Plus, my queries don't work where they used to about a week ago. My next step is to initdb --locale=C to confirm this. I've informed Magnus about this and he is looking into it. Merlin ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend