| From: | "Merlin Moncure" <mmoncure(at)gmail(dot)com> |
|---|---|
| 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:38:09 |
| Message-ID: | b42b73150709280538n723444bbpe18572618cdb9f92@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 9/28/07, Stefan Schwarzer <stefan(dot)schwarzer(at)grid(dot)unep(dot)ch> wrote:
> Hi there,
>
> how can I avoid results like this: 9.50184e+06
>
> Instead it should return the "real" value, as 950184.
The type 'real' in postgresql comes from the mathematical definition
of real, numbers that can be expressed as a fraction, or rational
numbers. In a practical sense, it is an alias for the binary floating
point type iirc.
In your case, it looks like you should be using the integer or the numeric type.
merlin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2007-09-28 12:46:27 | Re: How to avoid: 9.50184e+06 |
| Previous Message | Stefan Schwarzer | 2007-09-28 12:08:18 | How to avoid: 9.50184e+06 |