locale changes

Поиск
Список
Период
Сортировка
От Karel Zak
Тема locale changes
Дата
Msg-id Pine.LNX.3.96.1000720140305.11997L-101000@ara.zf.jcu.cz
обсуждение исходный текст
Ответы Re: locale changes
Список pgsql-patches
 In the atache is patch with this:

 SET LOCALE TO <value>
        Set locale to <value>, the <value> must be correct for
        current OS locale setting.

 SHOW LOCALE
        Show current locale setting for all categories.

 RESET LOCALE
        Set locale back to start-up setting.

 Now, possible is change locale environment from client without backend
restart and under one postmaster can run more backends with different
locale setting.

 All routines (formatting.c, cash.c, main.c) are correct for this change.

 BTW. --- how plan is 'money' datetype in 7.1, remove?

                     Karel

 An example:

test=# SHOW LOCALE;
NOTICE:  Locale setting: LANG=C, CTYPE=C, NUMERIC=C, TIME=C, COLLATE=C,
MONETARY=C, MESSAGES=C
SHOW VARIABLE
test=# SELECT to_char(1023.5, 'L 9999D9');
  to_char
-----------
    1023.5
(1 row)

test=# SET LOCALE TO 'de_DE';
SET VARIABLE
test=# SELECT to_char(1023.5, 'L 9999D9');
  to_char
------------
 DM  1023,5
(1 row)

test=# SET LOCALE TO 'en_US';
SET VARIABLE
test=# SELECT to_char(1023.5, 'L 9999D9');
  to_char
-----------
 $  1023.5
(1 row)

test=# RESET LOCALE;
RESET VARIABLE
test=# SELECT to_char(1023.5, 'L 9999D9');
  to_char
-----------
    1023.5
(1 row)

Вложения

В списке pgsql-patches по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] Update: mac.c update, patch now on ftp
Следующее
От: Tom Lane
Дата:
Сообщение: Re: locale changes