Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Fri, 28 Sep 2007 14:46:27 +0200
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.
Attachment:
signature.asc
Description: Digital signature
- References:
- How to avoid: 9.50184e+06
- From: Stefan Schwarzer
- How to avoid: 9.50184e+06
- Prev by Date: Re: How to avoid: 9.50184e+06
- Next by Date: Re: question about pg_dump -a
- Previous by thread: Re: How to avoid: 9.50184e+06
- Next by thread: Re: How to avoid: 9.50184e+06
- Indexes: