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.