Forum OpenACS Q&A: Response to Postgres smart sort order for book titles...

I'm not sure I understand the question.  Why can't you "mess with the select"?  Instead of "order by title" say "order by title_words(title)" and define a function title_words that strips out "the", "a", "is", etc. and only leaves the "important" stuff.  You can create an index on this function to further speed things if you need to.