On Tue, 16 Aug 2011, David Johnston wrote:
> Your INSERT statement is syntactically incorrect; the error has nothing to
> do with PSQL other than the fact that PSQL is reporting the error to you.
David,
I see that now.
> Odds are you are wrapping your Boolean input with single quotes and the
> empty string is not valid input for a Boolean. Because of the quotes the
> system will not use NULL since the input data is not missing but instead
> it has the empty-string as a value.
Yep. Gotta' correct them all so the proper columns are listed and those
with no values are not.
Thanks for pointing out the obvious.
Rich
