Home > mailing lists

"invalid input syntax for integer" for number with exponent - Mailing list pgsql-novice

From	Stephen Froehlich
Subject	"invalid input syntax for integer" for number with exponent
Date	March 1, 2018 03:16:37
Msg-id	CY1PR0601MB1927118F7341CAD19719D77EE5C70@CY1PR0601MB1927.namprd06.prod.outlook.com Whole thread Raw
Responses	Re: "invalid input syntax for integer" for number with exponent (Bzzzz <lazyvirus@gmx.com>)
List	pgsql-novice

I’m getting the following error when trying to go from R to a bigint field in PostgreSQL.

COPY invalid input syntax for integer: "1.12589990684262e+015"

Do I need to convert the number into text manually in R? Exactly what about this input is confusing PostgreSQL?

Thanks,

Stephen

Stephen Froehlich
Sr. Strategist, CableLabs^®

Tel: +1 (303) 661-3708

From: Andreas Kretschmer
Date: 27 February 2018, 01:50:44
Subject: Re: Reboot standby

From: Bzzzz
Date: 01 March 2018, 03:24:20
Subject: Re: "invalid input syntax for integer" for number with exponent