[SQL] Unable to identify a right operator '>=' for type 'bpchar'

[Michael Ma]

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