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.