Re: How to avoid: 9.50184e+06

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Stefan Schwarzer <stefan(dot)schwarzer(at)grid(dot)unep(dot)ch>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to avoid: 9.50184e+06
Date: 2007-09-28 12:46:27
Message-ID: 20070928124627.GB12509@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Sep 28, 2007 at 02:08:18PM +0200, Stefan Schwarzer wrote:
> how can I avoid results like this: 9.50184e+06
>
> Instead it should return the "real" value, as 950184.

Presumably to_text would do what you want. Alternatively, perhaps you
intended your column to be type numeric?

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ottavio Campana 2007-09-28 13:07:01 Re: question about pg_dump -a
Previous Message Merlin Moncure 2007-09-28 12:38:09 Re: How to avoid: 9.50184e+06