subject:"Re\: \[GENERAL\] copy 5.3000000000e\+01 to bigint column error while Insert ok"

Re: [GENERAL] copy 5.3000000000e+01 to bigint column error while Insert ok

2013-10-29 Thread Jov

thanks,that make sense.changing the column type from bigint to double pecision solves the problem. Jov blog: http:amutu.com/blog 2013/10/29 John R Pierce > On 10/28/2013 11:34 PM, Jov wrote: > > when use insert command,we can insert 5.30e+01 to table,but when >

Re: [GENERAL] copy 5.3000000000e+01 to bigint column error while Insert ok

2013-10-28 Thread John R Pierce

On 10/28/2013 11:34 PM, Jov wrote: when use insert command,we can insert 5.30e+01 to table,but when use copy command,we get this: ERROR: invalid input syntax for integer: "'5.30e+01'" CONTEXT: COPY tdsort_metrics, line 1, column monitor_value: "'5.30e+01'" any idea?