> > 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
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
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 beha
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
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.
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: zero-len
