From: | Edoardo Panfili <edoardo(at)aspix(dot)it> |
---|---|
To: | Bryan Herger <bryanh(at)autonomy(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: ORDER BY: lexicographic ordering of names |
Date: | 2009-03-19 06:34:50 |
Message-ID: | 538076653.8311237444465698.JavaMail.root@vnr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Il 18-03-2009 21:32, Bryan Herger ha scritto:
> 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?
Some time ago I had a problem with string sorting related to my locale
(but with "*" instead of "'"), now all works adding
"ORDER BY column USING ~<~".
I did I try with your data but I obtain the same sorting of MSSQL both
in my locale and using ~<~.
Edoardo
From | Date | Subject | |
---|---|---|---|
Next Message | Milos Findura | 2009-03-19 09:12:26 | deadlock problem |
Previous Message | Tom Lane | 2009-03-19 01:06:37 | Re: ORDER BY: lexicographic ordering of names |