On Sat, Sep 2, 2017 at 10:10 AM, Melvin Davidson <melvin6925@xxxxxxxxx> wrote: > > > On Sat, Sep 2, 2017 at 11:54 AM, Francisco Olarte <folarte@xxxxxxxxxxxxxx> wrote: >> >> On Sat, Sep 2, 2017 at 4:16 PM, Олег Самойлов <olleg@xxxxxxx> wrote: >> > Hi all. I have silly question. Look at "numeric" type. According to >> > docs it must be "up to 131072 digits before the decimal point; up to >> > 16383 digits after the decimal point". Well, lets see. >> > >> > => select 1::numeric/3; >> > ?column? >> > ------------------------ >> > 0.33333333333333333333 >> >> => select 1::numeric(100,90)/3; >> ?column? >> ---------------------------------------------------------------------------------------------- >> 0.333333333333333333333333333333333333333333333333333333333333333333333333333333333333333333 >> (1 row) >> >> It's probably doing 1(integer) => double precioson => numeric(20) or >> something similar if you do not specify. >> >> Francisco Olarte. >> >> >> -- >> Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general > > > Franciso, > > Per the docs, is is not "must be', it is "up to 131072 digits before the decimal point; up to 16383 digits after the decimal point". > https://www.postgresql.org/docs/9.6/static/datatype-numeric.html#DATATYPE-NUMERIC-TABLE > > YOU have specified a precision of numeric(100,90), which means 90 decimals and that is exactly what you got! > The result is correct, so what is your question? > > Huh. I'm guessing that the cast is the limit here: smarlowe=# select 1::numeric(1001,500); ERROR: NUMERIC precision 1001 must be between 1 and 1000 LINE 1: select 1::numeric(1001,500); -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
