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@xxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
