Re: query configuration for validate empty quote to zero

The problem is not stop there, I had a table that can't be updated since
then with this simply command:
update prdttable set webinclude = '0' where prdtnumber = '6002'

Again, the errors (invalid input syntax for integer: "") apears.

Then I found this temporary solution to make replica to this record to
another table in sense of update the value in the new table.
1. Create table prdt_problem as select * form prdttable where prdtnumber =
'6002';

2. Update prdt_problem set webinclude = '0' where prdtnumber = '6002';

3. Delete from prdttable where prdtnumber = '6002';

4. Insert into prdttable select * from prdt_problem

How to fix this bug?

> None.  That's an intentional change.  The fact that it ever accepted
> '' as meaning 0 was a bug.
>
> regards, tom lane
>