Re: [GENERAL] Query and index ... unexpected result need advice.

2012-12-10 Thread Jeff Janes
On Sun, Dec 9, 2012 at 10:59 PM, Condor wrote: > On 2012-12-10 00:31, Jeff Janes wrote: >> >> On Sat, Dec 8, 2012 at 5:54 AM, Condor wrote: >> >>> create index clients_tbl_firstname_idx on clients_tbl using btree >>> (firstname >>> COLLATE "bg_BG" text_pattern_ops); >> >> >> I don't understand w

Re: [GENERAL] Query and index ... unexpected result need advice.

2012-12-09 Thread Condor
On 2012-12-10 00:31, Jeff Janes wrote: On Sat, Dec 8, 2012 at 5:54 AM, Condor wrote: I am interested to know where is my mistake or something wrong with server which I doubt. Here is my current query with explain: (I change names to XXX YYY ZZZ because original names is written on CP1251 and

Re: [GENERAL] Query and index ... unexpected result need advice.

2012-12-09 Thread Jeff Janes
On Sat, Dec 8, 2012 at 5:54 AM, Condor wrote: > I am interested to know where is my mistake or something wrong > with server which I doubt. Here is my current query with explain: > (I change names to XXX YYY ZZZ because original names is written on CP1251 > and most ppl in list can't read them) >