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;