Re: pg7.3.4: pg_atoi: zero-length string
Andrew Sullivan <andrew@libertyrms.info>
From: Andrew Sullivan <andrew@libertyrms.info>
To: pgsql-general@postgresql.org
Date: 2003-11-04T14:18:23Z
Lists: pgsql-general
On Tue, Nov 04, 2003 at 12:19:58PM +0000, 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!=NULL).
SQL uses three-valued logic.
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Afilias Canada Toronto, Ontario Canada
<andrew@libertyrms.info> M2P 2A8
+1 416 646 3304 x110