Error when comparing an integer to an empty string.

From: David Pradier <dpradier(at)apartia(dot)fr>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Error when comparing an integer to an empty string.
Date: 2002-11-21 16:30:10
Message-ID: 20021121163010.GA27054@apartia.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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-length string

\d operation gives :
id_operation | integer | not null default nextval('"operation_type_id_operation_seq"'::text)

Is this a bug or a feature of the new 7.3 version ?
Is there a purpose ?

Thanks for your help.

Best regards,
David.
--
dpradier(at)apartia(dot)fr

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruno Wolff III 2002-11-21 17:07:55 Re: Error when comparing an integer to an empty string.
Previous Message David Wheeler 2002-11-21 16:13:52 Re: DBD::PostgreSQL