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.
It's
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.
Example :
=# select nom_comm from operation where id_operation = '';
ERROR: pg_atoi:
Louis-David Mitterrand [EMAIL PROTECTED] writes:
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?
Louis-David Mitterrand [EMAIL PROTECTED] 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