Re: INSERTing rows from external file

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: INSERTing rows from external file
Date: 2011-08-16 22:23:28
Message-ID: 76303302-042C-43A7-8A17-57329AD1598C@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Aug 16, 2011, at 4:13 PM, Rich Shepard wrote:

> Here's the full statement for the last row:
>
> psql:chem_too.sql:5517: ERROR: invalid input syntax for type boolean: ""
> LINE 1: ...NS','1996-11-21','Potassium','0.949999988','mg/L','','','','...
> ^
> The column is NULLable and if there's no value a NULL should be entered.

An empty string is not null.

--
Scott Ribe
scott_ribe(at)elevated-dev(dot)com
http://www.elevated-dev.com/
(303) 722-0567 voice

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2011-08-16 22:48:27 Re: INSERTing rows from external file
Previous Message David Johnston 2011-08-16 22:21:05 Re: INSERTing rows from external file