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 <[EMAIL PROTECTED]> 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)
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
