How to sort Norwegian text on Postgres
The order is correct. In Norwegian "aa" is the spelling of "å" and it should go at the end.
Source: https://en.wikipedia.org/wiki/%C3%85
Correct alphabetization in Danish and Norwegian places Å as the lastletter in the alphabet, the sequence being Æ, Ø, Å. This is also truefor the alternative spelling "Aa". Unless manually corrected, sortingalgorithms of programs localised for Danish or Norwegian will placee.g., Aaron after Zorro.