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

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;
> >
> > HTH
> >
> > Darren