Vincent Veyron <vv.lists@xxxxxxxxxx> writes: > Tom Lane <tgl@xxxxxxxxxxxxx> 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
