Re: index returns different output

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: viktor(at)solon(dot)Colorado(dot)EDU
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: index returns different output
Date: 2000-11-05 00:45:11
Message-ID: 24474.973385111@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

What LOCALE setting do you run the postmaster in?

This looks like it might be the known problem with LIKE index
optimization not coping very well with non-ASCII collation orders.
(It tries, but if you have collation rules where multicharacter
patterns are treated specially, it tends to do the wrong thing...)

You can find lots of discussion about this in the pgsql mailing
list archives. I don't think anyone's worked out a complete solution
short of not doing the optimization at all in non-ASCII locales :-(

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2000-11-05 01:38:37 Re: index returns different output
Previous Message Viktor Przebinda 2000-11-04 21:25:10 index returns different output