Re: [GENERAL] ascii() for utf8 - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: [GENERAL] ascii() for utf8
Date
Msg-id 20070731135531.GD5103@alvh.no-ip.org
Whole thread Raw
In response to Re: [GENERAL] ascii() for utf8  (Decibel! <decibel@decibel.org>)
Responses Re: [GENERAL] ascii() for utf8  ("Stuart McGraw" <smcg2297@frii.com>)
Re: [GENERAL] ascii() for utf8  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
Decibel! wrote:
> Moving to -hackers.
>
> On Jul 27, 2007, at 1:22 PM, Stuart wrote:
>> Does Postgresql have a function like ascii() that will
>> return the unicode codepoint value for a utf8 character?
>> (And symmetrically same for question chr() of course).

> I suspect that this is just a matter of no one scratching the itch. I 
> suspect a patch would be accepted, or you could possibly put something on 
> pgFoundry.

Nay; there were some discussions about this not long ago, and I think
one conclusion you could draw from them is that many people want these
functions in the backend.

> I'd set it up so that ascii() and chr() act according to the 
> appropriate locale setting (I'm not sure which one would be appropriate).

I don't see why any of them would react to the locale, but they surely
must honor client encoding.

-- 
Alvaro Herrera                               http://www.PlanetPostgreSQL.org/
"I dream about dreams about dreams", sang the nightingale
under the pale moon (Sandman)


pgsql-hackers by date:

Previous
From: "Dawid Kuroczko"
Date:
Subject: Re: Machine available for community use
Next
From: Decibel!
Date:
Subject: Re: Quick idea for reducing VACUUM contention