numeric data type upper limit. - Mailing list pgsql-novice

From Aravind Kumar
Subject numeric data type upper limit.
Date
Msg-id CADhiBKbzC2=SfOqC5kotX+tpUrYgBtWvn=UcMGWv=i-d7NYTow@mail.gmail.com
Whole thread Raw
Responses Re: numeric data type upper limit.  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: numeric data type upper limit.  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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


pgsql-novice by date:

Previous
From: Tyler Veinot
Date:
Subject: Re: GUI client
Next
From: "David G. Johnston"
Date:
Subject: Re: numeric data type upper limit.