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@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice