"invalid input syntax for integer" for number with exponent

From: Stephen Froehlich <s(dot)froehlich(at)cablelabs(dot)com>
To: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: "invalid input syntax for integer" for number with exponent
Date: 2018-02-28 21:16:37
Message-ID: CY1PR0601MB1927118F7341CAD19719D77EE5C70@CY1PR0601MB1927.namprd06.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(r)

s(dot)froehlich(at)cablelabs(dot)com<mailto:s(dot)froehlich(at)cablelabs(dot)com>
Tel: +1 (303) 661-3708

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Bzzzz 2018-02-28 21:24:20 Re: "invalid input syntax for integer" for number with exponent
Previous Message Andreas Kretschmer 2018-02-26 19:50:44 Re: Reboot standby