You will need to cats '01044T' to bpchar since postgres will take any
string as a varchar unless specified otherwise.
Use the following
DELETE FROM inventory WHERE invid = '01044T'::VARCHAR;
HTH
Darren
On Wed, 17 Jul 2002, Daniel Bakken wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
--
Darren Ferguson