Re: unexpected character used as group separator by to_char

Vincent Veyron <vv.lists@wanadoo.fr> writes:
> Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> (I suppose you could also use regexp_replace to convert random forms
>> of whitespace to plain ASCII space.)

> No dice. 'G' formatting looks like a whitespace, but is different (it appears to be slightly narrower when displayed in html, too)  :

Huh ... do you have lc_monetary and lc_ctype set the same?  The
latter is (I believe) what determines the behavior of regex \s.

In any case, you could force the issue with a pattern like '[\s\uNNNN]'
for whatever the code point of that character is.

			regards, tom lane