Re: How to avoid: 9.50184e+06

On 9/28/07, Stefan Schwarzer <stefan.schwarzer@grid.unep.ch> wrote:
> Hi there,
>
> how can I avoid results like this: 9.50184e+06
>
> Instead it should return the "real" value, as 950184.
>
> Thanks for any hints!

Cast it to numeric:

select 9.50184e+06::real::numeric;

But know that you're losing accuracy if you're working with real / float types.

If you need all the parts of the number kept around, use numeric from the start.