Andrew Sullivan wrote:
On Tue, Nov 04, 2003 at 11:21:35AM +0000, Rob Fielding wrote:
Hi,
We're currently experiencing a problem where SQL statements are failing when entring a '' for not not-null integer columns:
Yes. This behaviour was made more compliant in 7.3. It's in the release notes.
The above example in just one case where 'aid' can accept a null value.
I've found this is a feature of 7.3 to not treat a empty string as a NULL integer type. Silly lazy me ;)
As it turned out it relatively trivial to fix the offending statements on the few occasions where it has been valid to do this.
Consider this a non-issue.
Cheers,
--
Rob Fielding Development Designer Servers Ltd
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
