Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group