Re: order by problem - Mailing list pgsql-sql

From Tomasz Myrta
Subject Re: order by problem
Date
Msg-id 41AEC1AB.8030200@klaster.net
Whole thread Raw
In response to order by problem  (Simon Moses <ks_moses@yahoo.com>)
List pgsql-sql
>dear sir,
>when i run a query with order by customer_name i am
>getting the following result(ex.).
>
>AA
>A B
>AC
>
>i want it to be
>
>A B
>AA
>AB
>  
>
It's because of locales. Some special characteres are removed when 
sorting using locales. I'm not sure, but probably only "C" locale will 
give results you need.

Regards,
Tomasz Myrta


pgsql-sql by date:

Previous
From: sad
Date:
Subject: Re: SET AUTOCOMMIT TO OFF
Next
From: "Iain"
Date:
Subject: Re: invalid 'having' clause