Jeevan Chalke <jeevan.chalke@enterprisedb.com> writes:
> With PG84, I have tried something like this which seem incorrect to me.
> # SELECT '' AS to_number_2, to_number('-347,58', '99G999');
Well, the input doesn't actually match the format, so I'm not totally
excited about this. You do get sane results from:
regression=# select to_number('-347,58', '999G99');to_number
----------- -34758
(1 row)
Should we have it throw an error if the input corresponding to a G
symbol doesn't match the expected group separator? I'm concerned that
that would break applications that work okay today.
regards, tom lane