Re: DELETE FROM error message - Mailing list pgsql-general

FYI, I don't get that error message when I SELECT. For instance:

SELECT * FROM inventory WHERE invid = '01044T';

works just fine with no errors. When I try to delete that same record, I get
the error about explicit casts.

Daniel Bakken

> I tried your suggestion (both ways), but I still get the same
> error message
> about explicit casts.
>
> Daniel Bakken
>
> > 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;