Re: ORDER BY: lexicographic ordering of names

Alvaro Herrera <alvherre@commandprompt.com> writes:
> Bryan Herger wrote:
>> I am porting a database from MS SQL Server to Postgres.  One of the
>> tables contains a list of names, which I would like to list
>> alphabetically.  I noticed in the "O" names the following difference:

> Note to whoever answers: this is a frequent question, so consider adding
> your answer to the FAQ on the wiki,

Done...
http://wiki.postgresql.org/wiki/FAQ#How_do_I_change_the_sort_ordering_of_textual_data.3F

            regards, tom lane