Message-ID: <008101c4fccc$16d8a040$a101a8c0@home.axiontech.com>
From: "Yudie" <yudie@axiontech.com>
To: "Tom Lane" <tgl@sss.pgh.pa.us>
Cc: <pgsql-sql@postgresql.org>
References: <000d01c4fcc4$90fc9b40$a101a8c0@home.axiontech.com>
	<9227.1105989789@sss.pgh.pa.us>
Subject: Re: query configuration for validate empty quote to zero 
Date: Mon, 17 Jan 2005 13:30:03 -0600
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

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
>