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
