strcoll_l an new approach for locale per column

From: Mahmoud Taghizadeh <m_taghi(at)yahoo(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: strcoll_l an new approach for locale per column
Date: 2004-12-22 09:12:36
Message-ID: 20041222091236.61241.qmail@web50707.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

in this list there is some discussion about adding
support locale per column.
as far as I know the final result was that:
because postgresql uses glibc locale functions, and
because glibc only handle one locale, postgresql also
suppor only one locale at the same time.

one solution was that use some help functions (such as
nls_sort, or strxfrm...) and use setlocale to support
other locale.

the main problem with these solutions was that
1. it is not standart
2. the overhead of setlocale is too high

as far as I investigate the glibc code, I found some
extention function such as strcol_l and strxfrm_l that
let you to pass locale to them. so you dont have to
change locale repeatedly.

I want to know the groups idea?

Best Regards


__________________________________
Do you Yahoo!?
Send holiday email and support a worthy cause. Do good.
http://celebrity.mail.yahoo.com

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Richard Huxton 2004-12-22 09:41:40 Re: Thoughts about updateable views
Previous Message Hannu Krosing 2004-12-22 09:03:11 Re: getting 'order by' working with unicode locale? ICU?