Re: Server locale?

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: Server locale?
Дата
Msg-id 20021008072516.GC558@svana.org
обсуждение исходный текст
Ответ на Re: Server locale?  (Karel Zak <zakkr@zf.jcu.cz>)
Ответы Re: Server locale?
Список 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 по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: [pgsql-performance] Large databases, performance
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: How to find out about index