Re: Error when comparing an integer to an empty string.

From: Neil Conway <neilc(at)samurai(dot)com>
To: Louis-David Mitterrand <vindex(at)apartia(dot)org>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Error when comparing an integer to an empty string.
Date: 2002-11-21 18:16:50
Message-ID: 87k7j63i0d.fsf@mailbox.samurai.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Louis-David Mitterrand <vindex(at)apartia(dot)org> 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?

Yes.

I raised it as a possible point of backwards incompatibility at the
time the change was made, but the consensus was that this behavior was
worth getting rid of.

Cheers,

Neil

--
Neil Conway <neilc(at)samurai(dot)com> || PGP Key ID: DB3C29FC

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2002-11-21 18:20:17 Re: xBSD shmem doc deficiency
Previous Message Louis-David Mitterrand 2002-11-21 17:43:44 Re: Error when comparing an integer to an empty string.