"Wang, Mary Y" <mary.y.w...@boeing.com> writes:
> Can someone provide a link to the Postgres 8.x documentation that provides
> information about Null vs. Empty String?
> Here is the situation:
> Currently, the source code performs the following SQL statement :
> UPDATE user_group set subversion_flags='' WHERE user_id='5818' AND
> group_id='438';
> (This SQL statement worked in a very old version of Postgres)
> and pgsql 8.3.8 returned ERROR: invalid input syntax for integer: ""
You were not getting a NULL there. You were getting an integer zero,
as a result of sloppy input checking in the integer-input routine.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
