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:

Further reading

• PostgreSQL-FAQ: Why do my strings sort incorrectly? Show archive.org snapshot