From: | Олег Самойлов <olleg(at)mipt(dot)ru> |
---|---|
To: | Francisco Olarte <folarte(at)peoplecall(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Numeric numbers |
Date: | 2017-09-02 17:04:59 |
Message-ID: | 1504371899.7221.1.camel@mipt.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sat, 2017-09-02 at 18:58 +0200, Francisco Olarte wrote:
> CCing the list ( hint: use reply all in your MUA, otherwhise people
> will loose the thread, this message came only for me. If that was
> what
> you wnated, please indicate so in future messages, as the custom in
> this list is to reply to list + posters )
Got it.
>
> On Sat, Sep 2, 2017 at 6:21 PM, Олег Самойлов <olleg(at)mipt(dot)ru> wrote:
> >
> > On Sat, 2017-09-02 at 17:54 +0200, Francisco Olarte wrote:
> > >
> > > It's probably doing 1(integer) => double precioson => numeric(20)
> > > or
> > > something similar if you do not specify.
> > >
> > > Francisco Olarte.
> > Well, the question was not only about why there is only 20 "3"
> > after
> > point, I suspect this (may be it's not good enough documented, but
> > reasonable), but also about why are there infinite amount of "0"
> > after
> > point if I subtract "3"s.
> Well, I just skipped over the rest of the code. I consider casting to
> unespecified numeric widths a very bad habit and did not want to
> encourage it.
>
> Francisco Olarte.
There is nothing in documentation that this casting is a very bad
habit. And this is most interesting part, about infinite zeros. Looked
like a bug.
From | Date | Subject | |
---|---|---|---|
Next Message | Gilles Darold | 2017-09-02 17:10:39 | pgFormatter v2.1 has been released |
Previous Message | Francisco Olarte | 2017-09-02 16:58:48 | Re: Numeric numbers |