Re: How to order varchar data by word

Hello, Tom.

Thank you for your e-mail

Even though I am not familiar with the exact procedure to switch to other 
locales,
I'm gonna research this more deeply.

Anyway, I would appreciate if you could spare me some time and give me a 
couple of pointers to this subject.

Again, thank you

Best,
Oliveiros

----- Original Message ----- 
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Oliveiros C," <oliveiros.cristina@marktest.pt>
Cc: "Adrian Klaver" <aklaver@comcast.net>; <pgsql-sql@postgresql.org>
Sent: Monday, October 19, 2009 6:32 PM
Subject: Re: [SQL] How to order varchar data by word


> "Oliveiros C," <oliveiros.cristina@marktest.pt> writes:
>> If any one can explain me exactly how the order by clause works on 
>> varchars,
>> I 'd really appreciate it.
>
> It sorts according to the sort order imposed by your locale setting
> (see LC_COLLATE in particular).
>
> A lot of locales have weird and wonderful rules that embody somebody's
> notion of "dictionary order".  If you don't like it, try switching to
> C locale.  Or you could learn enough about locale definitions to create
> your own.
>
> regards, tom lane
>
> -- 
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql