Re: How to add locale support for each column?

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: peter_e(at)gmx(dot)net
Cc: m_taghi(at)yahoo(dot)com, pgsql-hackers(at)postgresql(dot)org
Subject: Re: How to add locale support for each column?
Date: 2004-09-20 00:02:04
Message-ID: 20040920.090204.85398953.t-ishii@sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

> 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jan Wieck 2004-09-20 01:46:20 Re: Disabling bgwriter on my notebook
Previous Message Greg Stark 2004-09-19 21:00:44 Re: How to add locale support for each column?

Browse pgsql-patches by date

  From Date Subject
Next Message Neil Conway 2004-09-20 00:05:01 documentation fixes
Previous Message Michael Paesold 2004-09-19 21:17:44 Re: Fix for VACUUM in psql autocommit off