Postgres Pro
Downloads
Home   >   mailing lists

DELETE FROM error message - Mailing list pgsql-general

From Daniel Bakken
Subject DELETE FROM error message
Date
Msg-id EFELIOJNFEDFOHLPCGEJMEELEIAA.dan@smtresource.com
Whole thread Raw
Responses Re: DELETE FROM error message  (Darren Ferguson <darren@crystalballinc.com>)
List pgsql-general
Tree view 
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@smtresource.com

SMT Resource | www.smtresource.com

254.771.3508   phone
254.771.3786   fax

pgsql-general by date:

Previous
From: "Johnson, Shaunn"
Date:
Subject: pg_restore: archiver error
Next
From: Rob Brown-Bayliss
Date:
Subject: Basic replication query