pg_atoi error - Mailing list pgsql-novice

From LIANHE SHAO
Subject pg_atoi error
Date
Msg-id f41876f40f99.f40f99f41876@jhmimail.jhmi.edu
Whole thread Raw
Responses Re: pg_atoi error
List 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


pgsql-novice by date:

Previous
From: Aarni Ruuhimäki
Date:
Subject: 7.4.1 template1
Next
From: Bruno Wolff III
Date:
Subject: Re: pg_atoi error