Postgres Pro
Downloads
Home   >   mailing lists

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

From David G. Johnston
Subject Re: numeric data type upper limit.
Date
Msg-id CAKFQuwY-9bDYHggBA63Vy_jKZKMusq_HXf96+iHpt546fM3pMg@mail.gmail.com
Whole thread Raw
In response to numeric data type upper limit.  (Aravind Kumar <aravindc26@gmail.com>)
Responses Re: numeric data type upper limit.
List pgsql-novice
Tree view
On Sunday, August 14, 2016, Aravind Kumar <aravindc26@gmail.com> wrote:
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 ?


Guessing here but I think numeric input requires single quotes around the value.

David J.

pgsql-novice by date:

Previous
From: Aravind Kumar
Date:
Subject: numeric data type upper limit.
Next
From: Aravind Kumar
Date:
Subject: Re: numeric data type upper limit.