pg_atoi error

From: LIANHE SHAO <lshao2(at)jhmi(dot)edu>
To: PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org>
Subject: pg_atoi error
Date: 2004-01-23 15:01:15
Message-ID: f41876f40f99.f40f99f41876@jhmimail.jhmi.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello,

In my query:
select * from experimentinfo where expid='1';
here data type of expid is int.
My question is:
if I change expid ='xyz', error is: pg_atoi: error
in "xyz": can't parse "xyz"
if I change expid ='', error is: pg_atoi:
zero-length string

In mysql, seems this will not happen and will give
you 0 row result. but not error message.

So, How can I avoid these annoying message?

Regards,
William

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Bruno Wolff III 2004-01-23 15:12:15 Re: pg_atoi error
Previous Message Aarni Ruuhimäki 2004-01-23 13:47:44 7.4.1 template1