Glyn Astill <glynastill@xxxxxxxxxxx> writes: > I was just wondering if there's any way to tweak the way an an index is ordered on a text field? > I have a table with a varchar field "artist" (see table def below), and if I order by the field "artist" it does not order as expected when there are characters such as ^ at the start of the text. You didn't say what you consider "expected", but I suspect that the answer is you want to use a different locale setting ... probably C. Unfortunately there's currently no way to change that short of initdb. regards, tom lane
