Re: pg7.3.4: pg_atoi: zero-length string - Mailing list pgsql-general

From Rob Fielding
Subject Re: pg7.3.4: pg_atoi: zero-length string
Date
Msg-id 3FA7996E.9020705@dsvr.net
Whole thread Raw
In response to Re: pg7.3.4: pg_atoi: zero-length string  (Andrew Sullivan <andrew@libertyrms.info>)
Responses Re: pg7.3.4: pg_atoi: zero-length string  (Bruno Wolff III <bruno@wolff.to>)
Re: pg7.3.4: pg_atoi: zero-length string  (Andrew Sullivan <andrew@libertyrms.info>)
List pgsql-general

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


pgsql-general by date:

Previous
From: Victor Spång Arthursson
Date:
Subject: Very strange selectproblem
Next
From: Csaba Nagy
Date:
Subject: Re: Very strange selectproblem