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

From Bruce Momjian
Subject Re: [GENERAL] ascii() for utf8
Date
Msg-id 200709140319.l8E3JuS19926@momjian.us
Whole thread Raw
In response to Re: [GENERAL] ascii() for utf8  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: [GENERAL] ascii() for utf8
List pgsql-hackers
This has been saved for the 8.4 release:
http://momjian.postgresql.org/cgi-bin/pgpatches_hold

---------------------------------------------------------------------------

Alvaro Herrera wrote:
> 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)
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly

--  Bruce Momjian  <bruce@momjian.us>          http://momjian.us EnterpriseDB
http://www.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Reducing Transaction Start/End Contention
Next
From: Bruce Momjian
Date:
Subject: Re: clog_buffers to 64 in 8.3?