Hi,
While running the following SQL statement in postgresql-7.0-1 via
JDBC,
select a.cus_code, a.dlv_code, b.cus_abbr, a.dlv_abbr,
a.address, a.tel, a.fax, a.contact
from dlv_point a, customer b
where ((a.cus_code >= ? and a.cus_code <= ?)
or (b.cus_abbr >= ? and b.cus_abbr <= ?))
and trim(b.cus_code) = trim(a.cus_code)
order by 1 ;
I got the following error message:
Unable to identify a right operator '>=' for type 'bpchar'
You may meed to add parentheses or an explicit cast.
I have never got this kind of message from Informix or Oracle.
The data type of the fields in the above statement are all char(n).
Can anyone help?
The system I am using is Red Hat Linux 6.2 with Kernel 2.2.14-6.1.1 on
an i586
Thanks in advance.
Michael