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

From: Michael Ma <mikema(at)ficnet(dot)net>
To: pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: Unable to identify a right operator '>=' for type 'bpchar'
Date: 2000-05-24 15:21:39
Message-ID: 392BF383.689FB14B@ficnet.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message gomathi raju 2000-05-24 15:37:27
Previous Message Tom Lane 2000-05-24 04:44:30 Re: Decimal ??