Postgres Pro
Downloads
Home   >   mailing lists

DELETE FROM error - Mailing list pgsql-general

From Daniel Bakken
Subject DELETE FROM error
Date
Msg-id EFELIOJNFEDFOHLPCGEJIEEKEIAA.dan@smtresource.com
Whole thread Raw
Responses Re: DELETE FROM error  (Tom Lane <tgl@sss.pgh.pa.us>)
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: brendanl@iname.com (Brendan LeFebvre)
Date:
Subject: Stubborn lock(?) with psqlODBC+MSAccess
Next
From: trev@trev.co.nz (Trev)
Date:
Subject: Re: ERROR: bt_fixroot: not valid old root page