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.
>
> 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.
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
