On 9/28/07, Stefan Schwarzer <stefan.schwarzer@xxxxxxxxxxxx> 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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
