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

From: Rob Fielding <rob(at)dsvr(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: pg7.3.4: pg_atoi: zero-length string
Date: 2003-11-04 13:26:47
Message-ID: 3FA7A917.70102@dsvr.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jan Poslusny 2003-11-04 13:37:07 Databases with different encodings
Previous Message Bruno Wolff III 2003-11-04 13:19:31 Re: pg7.3.4: pg_atoi: zero-length string