Jeevan Chalke <jeevan(dot)chalke(at)enterprisedb(dot)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