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