thanks,that make sense.changing the column type from bigint to double pecision solves the problem.
Jov blog: http:amutu.com/blog <http://amutu.com/blog> 2013/10/29 John R Pierce <pie...@hogranch.com> > On 10/28/2013 11:34 PM, Jov wrote: > > when use insert command,we can insert 5.3000000000e+01 to table,but when > use copy command,we get this: > ERROR: invalid input syntax for integer: "'5.3000000000e+01'" > CONTEXT: COPY tdsort_metrics, line 1, column monitor_value: > "'5.3000000000e+01'" > > any idea? > > > that number is clearly a floating point number. INSERT takes > expressions, and will cast the float to bigint, COPY doesn't and won't. > > > -- > john r pierce 37N 122W > somewhere on the middle of the left coast > >
