Re: [HACKERS] LIKE and Locale

On Wed, 31 Mar 2004 [EMAIL PROTECTED] wrote: > > On Wed, 31 Mar 2004 [EMAIL PROTECTED] wrote: > > > >> I'm a little frustrated > >> > >> select * from mytable where mystring = 'foo'; > >> > >> Uses an index > >> > >> select * from mytable where mystring like 'foo'; > >> > >> Does not use an index

Re: [HACKERS] LIKE and Locale

On Wed, 31 Mar 2004 [EMAIL PROTECTED] wrote: > I'm a little frustrated > > select * from mytable where mystring = 'foo'; > > Uses an index > > select * from mytable where mystring like 'foo'; > > Does not use an index. > > I know Tom is not to excited about this, but I think it is a serious > pro

Re: [HACKERS] LIKE and Locale

> > On Wed, 31 Mar 2004 [EMAIL PROTECTED] wrote: > >> I'm a little frustrated >> >> select * from mytable where mystring = 'foo'; >> >> Uses an index >> >> select * from mytable where mystring like 'foo'; >> >> Does not use an index. >> >> I know Tom is not to excited about this, but I think it is

[HACKERS] LIKE and Locale

I'm a little frustrated select * from mytable where mystring = 'foo'; Uses an index select * from mytable where mystring like 'foo'; Does not use an index. I know Tom is not to excited about this, but I think it is a serious problem. What really brings me to this is that I just installed 7.4.2