Hi,
looking for the reverse of select '1.2923904e+07'::numeric::int;
every time, I have to select to_char(12923904,'9.9999999EEEE');
if I do select to_char(12923904,'9.999999EEEE');
then the result is different.
For integer or bigint can I automatically have something like:
select to_char(int,'9.(precision-1)EEEE');
--
I recommend David Deutsch's <<The Beginning of Infinity>>
Jian