Re: Error when comparing an integer to an empty string. - Mailing list pgsql-hackers

Louis-David Mitterrand <vindex@apartia.org> writes:
> with 7.2:
> 
>     template1=# select 1 = '';
>      ?column? 
>     ----------
>      f
>     (1 row)
> 
> 
> with 7.3rc1:
> 
>     template1=# select 1 = '';
>     ERROR:  pg_atoi: zero-length string
> 
> 
> Is this change of behavior intentional?

Yes.

I raised it as a possible point of backwards incompatibility at the
time the change was made, but the consensus was that this behavior was
worth getting rid of.

Cheers,

Neil

-- 
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC