Re: Is this "order by" logic right - Mailing list pgsql-general

From Josué Maldonado
Subject Re: Is this "order by" logic right
Date
Msg-id 3F71B5A9.6090901@lamundial.hn
Whole thread Raw
In response to Re: Is this "order by" logic right  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Responses Re: Is this "order by" logic right
List pgsql-general
Hi Stephan,

Stephan Szabo wrote:

> On Wed, 24 Sep 2003, [ISO-8859-1] Josué Maldonado wrote:
> You haven't given your locale or system type, but this seems reasonably
> if you're in a locale that generally ignores spaces (for example my redhat
> machine does so in en_US).  If you want byte order sorting, you'll
> probably need to re-initdb with LC_COLLATE set to "C"

The db was initialized with the defaults in postgresql.conf, so the
locale is en_US. Any idea how to change it?

--
Josué Maldonado.



pgsql-general by date:

Previous
From: Vivek Khera
Date:
Subject: Re: State of Beta 2
Next
From: Stephan Szabo
Date:
Subject: Re: Is this "order by" logic right