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 ?
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 the
definition of function nls_string(text, text) which takes a string
parameter 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')
select * from table order by nls_string(name, 'cs_CZ.UTF-8')
select * from table order by nls_string(name, 'C')
Lates version is available at:
Do you Yahoo!?
vote.yahoo.com - Register online to vote today!
pgsql-hackers by date
|Next:||From: Peter Eisentraut||Date: 2004-09-19 08:45:39|
|Subject: Re: How to add locale support for each column?|
|Previous:||From: Michael Paesold||Date: 2004-09-18 21:46:52|
|Subject: Re: SAVEPOINT SQL conformance |
pgsql-patches by date
|Next:||From: LELARGE Guillaume||Date: 2004-09-19 08:29:32|
|Subject: Re: French translation updates for 7.4 and 7.5|
|Previous:||From: Tom Lane||Date: 2004-09-18 20:46:16|
|Subject: Re: libpq and prepared statements progress for 8.0 |