I'm porting a procedure from Oracle to Postgres.
In select of a query, I have TO_CHAR(v_numeric, '990.000')
It seems, the same TO_CHAR(v_numeric, '990.000')
works in Postgres with same result.
Can someone please explain what the '990.000' in the query does?
TO_CHAR(123.4, '990.000')
returns 123.400 in both Oracle and Postgres. Whereas TO_CHAR(1234.400, '990.000')
returns ########
in Oracle and ###.###
in Postgres. Does this ########
and ###.###
hold the same numeric value which is inputted?