Skip site navigation (1) Skip section navigation (2)

Re: [pgsql-hackers-win32] select like...not using index

From: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>
To: <pgsql(at)mohawksoft(dot)com>
Cc: "PgSql-Win32" <pgsql-hackers-win32(at)postgresql(dot)org>,<pgsql-hackers(at)postgresql(dot)org>,"Magnus Hagander" <mha(at)sollentuna(dot)net>
Subject: Re: [pgsql-hackers-win32] select like...not using index
Date: 2004-06-01 15:28:00
Message-ID: 6EE64EF3AB31D5448D0007DD34EEB34101AE46@Herge.rcsinc.local (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-hackers-win32
> 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

pgsql-hackers by date

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

pgsql-hackers-win32 by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group