Re: How to avoid: 9.50184e+06

["Merlin Moncure" <mmoncure(at)gmail(dot)com>]

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

The type 'real' in postgresql comes from the mathematical definition
of real, numbers that can be expressed as a fraction, or rational
numbers.  In a practical sense, it is an alias for the binary floating
point type iirc.

In your case, it looks like you should be using the integer or the numeric type.

merlin