[PATCHES] Again!! locale per column for postgreSQL
Qustion: is this approach is suitable for solving the need for locale per column in PostgreSQL ? There is a function I attached to this mail. this function is similar to nls_sort. this function is written by Karel Zak, I dont know if he had tried to submit this code or not. In this distribution you will find file nls_string.c. It contains thedefinition of function nls_string(text, text) which takes a stringparameter and a locale name and returns string describing the ordering.So you can run select * from table order by nls_string(name, 'en_US.UTF-8')or select * from table order by nls_string(name, 'cs_CZ.UTF-8')or select * from table order by nls_string(name, 'C')M. taghizade Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers!
Re: [PATCHES] Again!! locale per column for postgreSQL
On Wed, 2004-09-15 at 07:01 -0700, Mahmoud Taghizadeh wrote: Qustion: is this approach is suitable for solving the need for locale per column in PostgreSQL ? There is a function I attached to this mail. this function is similar to nls_sort. this function is written by Karel Zak, I dont know if he had tried to submit this code or not. I think good place for this function is in the PG's contrib tree. The final solution for main tree have to be something different. I agree with you that this function can be useful for multi-language databases. Lates version is available at: http://www.fi.muni.cz/~adelton/l10n/postgresql-nls-string/ Karel -- Karel Zak http://home.zf.jcu.cz/~zakkr/ ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html