Postgres Pro
Downloads
Home   >   mailing lists

ORDER BY: lexicographic ordering of names - Mailing list pgsql-general

From Bryan Herger
Subject ORDER BY: lexicographic ordering of names
Date
Msg-id D82F64731BE07A4FB46D23F4D9D031BC01BE4DE8@VEX1.verity.com
Whole thread Raw
Responses Re: ORDER BY: lexicographic ordering of names  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: ORDER BY: lexicographic ordering of names  (Edoardo Panfili <edoardo@aspix.it>)
List pgsql-general
Tree view

All,

 

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:

 

MSSQL:

O’Daniel

O’Neill

Oliveira

Oliver

 

While PGSQL sorts as if the apostrophe was not there:

O’Daniel

Oliveira

Oliver

O’Neill

 

I think the MSSQL output is more correct for listing names alphabetically.  How can I configure or query PGSQL to get the same sort order?

 

Thanks,

Bryan

 

pgsql-general by date:

Previous
From: ray
Date:
Subject: Installation Error, Server Won't Start
Next
From: Raymond O'Donnell
Date:
Subject: Re: Installation Error, Server Won't Start