Re: problem with dots in order by

Thanks for the quick reply :)

I missed the localization part of the manual , shame on me !!
http://www.postgresql.org/docs/current/static/charset.html

LC_COLLATE String sort order

I did:
set|grep LC
and because I am portuguese it returns pt_PT

just a quick question if you please :
is there any implication in changing Postgresql to the C locale ...
other than
the order by and to_char handling ?

I'm running Postgresql as an ERP Database done by me and any mistakes I
do: I'm dead meat :P

If you have experience with this I welcome any reply ...
Other than that I will try in some other machine the
initdb --locale=C
just to be safe ...

Thanks again ,
Ruben Oliveira
-

Tom Lane wrote:

>Ruben Oliveira <ruben_dig(at)netcabo(dot)pt> writes:
>
>
>>Can anybody tell me if there is something I can do in the Linux config
>>to have the same order by result ??
>>
>>
>
>Sort order is determined by locale, not encoding. You did the Linux
>initdb in the wrong locale (possibly something like en_US where you'd
>rather have had C locale).
>
> regards, tom lane
>
>
>