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