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

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 <pierce(at)hogranch(dot)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
>
>