Re: DELETE FROM error message

DELETE FROM inventory WHERE invid = '01044T'::BPCHAR;

Robert Treat

On Wed, 2002-07-17 at 21:59, Darren Ferguson wrote:
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly