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(at)smtresource(dot)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(at)postgresql(dot)org)
>

--
Darren Ferguson