> 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

Responses

• Re: [pgsql-hackers-win32] select like...not using index at 2004-06-02 00:34:44 from pgsql

pgsql-hackers by date

Next:	From: Andrew Dunstan	Date: 2004-06-01 16:10:25
	Subject: Re: Official Freeze Date for 7.5: July 1st, 2004
Previous:	From: pgsql	Date: 2004-06-01 15:16:24
	Subject: Re: [pgsql-hackers-win32] select like...not using index

pgsql-hackers-win32 by date

Next:	From: roberthenkel	Date: 2004-06-01 18:53:45
	Subject: Re: nested transaction patch build?
Previous:	From: pgsql	Date: 2004-06-01 15:16:24
	Subject: Re: [pgsql-hackers-win32] select like...not using index