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

From Tom Lane
Subject Re: Error when comparing an integer to an empty string.
Date
Msg-id 13595.1037906084@sss.pgh.pa.us
Whole thread Raw
In response to Re: Error when comparing an integer to an empty string.  (Louis-David Mitterrand <vindex@apartia.org>)
List pgsql-hackers
Louis-David Mitterrand <vindex@apartia.org> writes:
> The point David was trying to make is: 
> 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.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] Bug with sequence
Next
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] Bug with sequence