On Tue, Mar 9, 2021 at 1:28 PM Vincent Veyron <vv(dot)lists(at)wanadoo(dot)fr> wrote:
> For the record below, I wish to display 'credit' properly formated in an
> html form, using to_char(credit, 'FM999G990D00')
>
> ^^^^^^^^^^^^^ ^^^^^^^^^^^^
> What can I do to get a standard space as group separator for my numbers?
>
By using "G" you are giving up control and letting your locale settings
decide what gets output. You can continue to use to_char but take control
back by being explicit, or pass actual numbers into and out of the database
and let your front-end deal with presentation concerns. I suggest the
latter.
David J.