Re: pg7.3.4: pg_atoi: zero-length string

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