Re: How to add locale support for each column?

Поиск
Список
Период
Сортировка
Искать
От
Tatsuo Ishii
Тема
Re: How to add locale support for each column?
Дата
Msg-id
20040920.090204.85398953.t-ishii@sra.co.jp
Ответ на
Список
Дерево обсуждения
How to add locale support for each column? Mahmoud Taghizadeh <m_taghi@yahoo.com>
Re: How to add locale support for each column? Peter Eisentraut <peter_e@gmx.net>
Re: How to add locale support for each column? Tatsuo Ishii <t-ishii@sra.co.jp>
Re: How to add locale support for each column? Greg Stark <gsstark@mit.edu>
Re: How to add locale support for each column? Tom Lane <tgl@sss.pgh.pa.us>
Re: How to add locale support for each column? Greg Stark <gsstark@mit.edu>
Re: How to add locale support for each column? Greg Stark <gsstark@mit.edu>
Re: How to add locale support for each column? Stephan Szabo <sszabo@megazone.bigpanda.com>
Re: How to add locale support for each column? Greg Stark <gsstark@mit.edu>
Re: How to add locale support for each column? Stephan Szabo <sszabo@megazone.bigpanda.com>
Re: How to add locale support for each column? Greg Stark <gsstark@mit.edu>
Re: How to add locale support for each column? Mahmoud Taghizadeh <m_taghi@yahoo.com>
Re: How to add locale support for each column? Tom Lane <tgl@sss.pgh.pa.us>
Re: How to add locale support for each column? Dennis Bjorklund <db@zigo.dhs.org>
Re: How to add locale support for each column? Greg Stark <gsstark@mit.edu>
Re: How to add locale support for each column? Stephan Szabo <sszabo@megazone.bigpanda.com>
Re: How to add locale support for each column? Dennis Bjorklund <db@zigo.dhs.org>
> Mahmoud Taghizadeh wrote:
> > I have already this mail to PATCHES mailing list and nobody replied
> > me !!!., Hope the hackers  and the developers send their ideas.
> >
> > Qustion: is this approach is suitable for solving the need for locale
> > per column in PostgreSQL ?
> 
> I doubt that, because 1) it's nonstandard, and 2) switching the locale 
> at run time is too expensive when using the system library.  It's a 
> good workaround, though, if it satisfies the requirements of your 
> application.

What about internal sorting, for example GROYP BY, UNION, merge join
etc.? These still use the per database cluster locale, that might be
inconsistent with per column locale and might lead to unwanted result,
no?
--
Tatsuo Ishii

В списке pgsql-hackers по дате отправления
От: Jan Wieck
Дата:
Сообщение: Re: signal 11 on AIX: 7.4.2
От: Jan Wieck
Дата:
FAQ