numeric data type upper limit.

From: Aravind Kumar <aravindc26(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: numeric data type upper limit.
Date: 2016-08-14 05:54:45
Message-ID: CADhiBKbzC2=SfOqC5kotX+tpUrYgBtWvn=UcMGWv=i-d7NYTow@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-novice

Hi,

when I do

select 1.0e+1001::numeric;

I get

invalid input syntax for type numeric: "1.0e+1001"

But

select 1.0e+1000::numeric;

seems to be valid.

Postgresql documentation tells me that numeric data type has an upper
limit of 131072 digits before decimal point.

Am I missing something ?

Regards

Aravind Chintalapalli

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message konstantin knizhnik 2016-08-14 06:54:40 Re: WIP: Barriers
Previous Message Amit Kapila 2016-08-14 05:03:23 Re: Surprising behaviour of \set AUTOCOMMIT ON

Browse pgsql-novice by date

  From Date Subject
Next Message David G. Johnston 2016-08-14 12:35:07 Re: numeric data type upper limit.
Previous Message Tyler Veinot 2016-08-09 23:43:05 Re: GUI client