Vincent Veyron <vv.li...@wanadoo.fr> writes:
> Having a database with the proper lc_numeric setting for each country, and
> using to_char/to_number to manipulate numbers is much more appealing than
> writing my own parser in my front end. But this weird space is getting in my
> way.
The point here is that 'G' and related format codes act as specified by
your LC_MONETARY locale. If you don't like the results, you need to use
a different locale.
(I suppose you could also use regexp_replace to convert random forms
of whitespace to plain ASCII space.)
regards, tom lane
