Re: Error when comparing an integer to an empty string.

On Thu, Nov 21, 2002 at 11:07:55AM -0600, Bruno Wolff III wrote:
> On Thu, Nov 21, 2002 at 17:30:10 +0100,
> David Pradier <dpradier(at)apartia(dot)fr> wrote:
> > Hi!
> >
> > I'm new on this list, my name is David Pradier, and i'm french.
> >
> > I'm currently trying the new postgresql 7.3rc1, and i've noticed that if
> > i compared an integer to an empty string, i ran in an error.
> >
> > Is this a bug or a feature of the new 7.3 version ?
> > Is there a purpose ?
>
> What number do you expect '' to represent?
>
> Probably you either want to use:
> = '0'
> or
> is null
> depending on what you are really trying to do.

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?

--
HIPPOLYTE: Trézène m'obéit. Les campagnes de Crète
Offrent au fils de Phèdre une riche retraite.
(Phèdre, J-B Racine, acte 2, scène 2)