Re: Server locale? - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Server locale?
Date
Msg-id 20021008072516.GC558@svana.org
Whole thread Raw
In response to Re: Server locale?  (Karel Zak <zakkr@zf.jcu.cz>)
Responses Re: Server locale?  (Karel Zak <zakkr@zf.jcu.cz>)
List pgsql-general
On Tue, Oct 08, 2002 at 09:07:49AM +0200, Karel Zak wrote:
> On Mon, Oct 07, 2002 at 10:17:35AM -0400, Tom Lane wrote:
> > 7.3 has some of the LC_ things exposed as GUC variables, but not
> > COLLATE.
>
>  Oh, sorry. By the way, why not COLLATE, why not all?

That's really wierd. Anyway, it means that from a users point of view, ORDER
BY on a string column has undefined results, since the server could be using
any locale and you have no way of determining what it is.

Best stick to sorting in the user code. Sigh.
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: [pgsql-performance] Large databases, performance
Next
From: Martijn van Oosterhout
Date:
Subject: Re: How to find out about index