Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group