Re: order by problem

From: Tomasz Myrta <jasiek(at)klaster(dot)net>
To: Simon Moses <ks_moses(at)yahoo(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: order by problem
Date: 2004-12-02 07:18:03
Message-ID: 41AEC1AB.8030200@klaster.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Iain 2004-12-02 07:46:22 Re: invalid 'having' clause
Previous Message sad 2004-12-02 05:11:49 Re: SET AUTOCOMMIT TO OFF