From: | "Yudie" <yudie(at)axiontech(dot)com> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: query configuration for validate empty quote to zero |
Date: | 2005-01-17 19:30:03 |
Message-ID: | 008101c4fccc$16d8a040$a101a8c0@home.axiontech.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2005-01-17 19:38:55 | Re: plpgsql and for with integer loopvar error |
Previous Message | Tom Lane | 2005-01-17 19:23:09 | Re: query configuration for validate empty quote to zero |