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

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 (view raw or flat)
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

pgsql-bugs by date

Next:From: Tom LaneDate: 2000-11-05 01:38:37
Subject: Re: index returns different output
Previous:From: Viktor PrzebindaDate: 2000-11-04 21:25:10
Subject: index returns different output

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