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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
