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 3FA7A917.70102@dsvr.net
Whole thread Raw
In response to Re: pg7.3.4: pg_atoi: zero-length string  (Andrew Sullivan <andrew@libertyrms.info>)
List pgsql-general

>>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
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: Bruno Wolff III
Date:
Subject: Re: pg7.3.4: pg_atoi: zero-length string
Next
From: Jan Poslusny
Date:
Subject: Databases with different encodings