PostgreSQL and its way of sorting strings

PostgreSQL uses the C library's locale facilities for sorting strings:

• First, all the letters are compared, ignoring spaces and punctuation.
• It sorts upper and lower case letters together. So the order will be something like a A b B c C
• Then, spaces and punctuation are compared to break ties.

Example:

PostgreSQL-FAQ: Why_do_my_strings_sort_incorrectly Show archive.org snapshot