When running the following DELETE FROM in psql,
omni=# DELETE FROM inventory WHERE invid = '01044T';
ERROR: Unable to identify an operator '=' for types 'varchar' and 'bpchar'
You will have to retype this query using an explicit cast
I receive the above error message. The field "invid" is a bpchar.
TIA,
Daniel Bakken, IT Systems Administrator
dan(at)smtresource(dot)com
SMT Resource | www.smtresource.com
254.771.3508 phone
254.771.3786 fax