xTuple.com xTupleU Blog & News Customer Support

Format numeric fails

Using xTuple 6.0.2

Morning all

I have a function call

select public.formatnumeric(3000,‘2’)::numeric

this returns the error

"SQL Error [22P02]: ERROR: invalid input syntax for type numeric: “3,000.00"”

but this returns 300 as expected

select public.formatnumeric(300,‘2’)::numeric

Does this happen to anyone else
or is my locale table messed up

Thank you

Bob

Oh I now see the problems

when the string to numeric crashes on the comma