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" <[email protected]>
To: "Oliveiros C," <[email protected]>
Cc: "Adrian Klaver" <[email protected]>; <[email protected]>
Sent: Monday, October 19, 2009 6:32 PM
Subject: Re: [SQL] How to order varchar data by word
"Oliveiros C," <[email protected]> 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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
--
Sent via pgsql-sql mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
