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
pgsql-general by date
|Next:||From: Ottavio Campana||Date: 2007-09-28 13:07:01|
|Subject: Re: question about pg_dump -a|
|Previous:||From: Merlin Moncure||Date: 2007-09-28 12:38:09|
|Subject: Re: How to avoid: 9.50184e+06|