> > > 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? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
