> > > Hi chaps, > > > > I was just wondering if there's any way to tweak > the way an an index is ordered on a text field? > > Yes, it's called functional index. Write your function, > which does > whatever you want with your data and create index > (foo(artist)) > Hmm, I understand what you're saying, but how ion earth do I create a function that reorders the result based on all the different characters ^ . * etc that could cause this? Also does anyone know why this happens? Why is the caret ignored ibn the index order - surely that just plain wrong?
