Re: numeric data type upper limit.

On Sun, Aug 14, 2016 at 6:05 PM, David G. Johnston
<david.g.johnston@gmail.com> wrote:
> 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.

Tried with single quotes doesn't seem to work. Possible bug ?

Aravind Chintalapalli