Re: Question about numeric

On Wed, 22 May 2002, Erwin Ambrosch wrote:

> Hi,
>
> when I import data from a text file (fildes are seperated with pipes) I get
> an error for fields of type numeric if there are no data for this fields.
>
> Example:
>
> CREATE TABLE mytable (
> id SERIAL,
> num VARCHAR(32),
> cost NUMERIC(6,2),
> info TEXT
> );
>
> A line to import from a text file.
>
> 1|123abc||This part is....
>
> Because of the empty field for the column cost, I get the following error:
>
> ERROR: copy: line 1, Bad numeric input format ''
> PQendcopy: resetting connection

Well '' isn't a valid numeric. If you were expecting a NULL, the default
NULL representation is \N. Try adding WITH NULL AS '' to your copy
command.