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

2000-05-24 Thread 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

Re: [SQL] Unable to identify a right operator '>=' for type 'bpchar' (solved)

2000-05-24 Thread Michael Ma 

It is solved and closed now.

Thanks