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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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 19:14:44
Message-ID: 13595.1037906084@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Yes.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2002-11-21 19:14:56 Re: [GENERAL] Bug with sequence
Previous Message Bruce Momjian 2002-11-21 19:11:08 Re: [HACKERS] [GENERAL] Bug with sequence