Skip site navigation (1) Skip section navigation (2)

How to add locale support for each column?

From: Mahmoud Taghizadeh <m_taghi(at)yahoo(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: How to add locale support for each column?
Date: 2004-09-19 06:53:40
Message-ID: 20040919065340.7389.qmail@web50710.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
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')

or

  select * from table order by nls_string(name, 'cs_CZ.UTF-8')

or

  select * from table order by nls_string(name, 'C')
 
Lates version is available at:
http://www.fi.muni.cz/~adelton/l10n/postgresql-nls-string/

M. Taghizadeh



		
---------------------------------
Do you Yahoo!?
vote.yahoo.com - Register online to vote today!

Attachment: postgresql-nls-string-0.53.tar.gz
Description: application/x-gzip (3.9 KB)

Responses

pgsql-hackers by date

Next:From: Peter EisentrautDate: 2004-09-19 08:45:39
Subject: Re: How to add locale support for each column?
Previous:From: Michael PaesoldDate: 2004-09-18 21:46:52
Subject: Re: SAVEPOINT SQL conformance

pgsql-patches by date

Next:From: LELARGE GuillaumeDate: 2004-09-19 08:29:32
Subject: Re: French translation updates for 7.4 and 7.5
Previous:From: Tom LaneDate: 2004-09-18 20:46:16
Subject: Re: libpq and prepared statements progress for 8.0

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group