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@apartia.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)