Re: DELETE FROM error message

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