The above example in just one case where 'aid' can accept a null value.
That's not a null. It's a zero-length string.
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
For the record, it _never_ treated it as NULL. It treated it as
"empty string". '' != NULL. In fact, !(NULL=NULL) & !(NULL!=NULL).
SQL uses three-valued logic.
You're absolutely right. That explains why, when I quickly looked, some
are zero's and some are NULLs - the NULLs where NULLs and
On Tue, Nov 04, 2003 at 12:19:58PM +, Rob Fielding wrote:
> I've found this is a feature of 7.3 to not treat a empty string as a
> NULL integer type. Silly lazy me ;)
For the record, it _never_ treated it as NULL. It treated it as
"empty string". '' != NULL. In fact, !(NULL=NULL) & !(NULL!
On Tue, Nov 04, 2003 at 12:19:58 +,
Rob Fielding <[EMAIL PROTECTED]> wrote:
>
> I've found this is a feature of 7.3 to not treat a empty string as a
> NULL integer type. Silly lazy me ;)
It didn't even then. It was treated as 0. Oracle is the DB that treats
empty strings as null values.
-
Andrew Sullivan wrote:
On Tue, Nov 04, 2003 at 11:21:35AM +, 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
Hi,
We're currently experiencing a problem where SQL statements are failing
when entring a '' for not not-null integer columns:
ERROR: pg_atoi: zero-length string
This was discovered just after a database migration from 7.2 to 7.3.4.
Example:
insert into renewal_cache
(dom,
> -Ursprüngliche Nachricht-
> Von: Andrew Sullivan [mailto:[EMAIL PROTECTED]
> Gesendet: Dienstag, 4. November 2003 12:32
> An: [EMAIL PROTECTED]
> Betreff: Re: [GENERAL] pg7.3.4: pg_atoi: zero-length string
>
>
> On Tue, Nov 04, 2003 at 11:21:35AM +, Rob F
On Tue, Nov 04, 2003 at 11:21:35AM +, 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 abov
