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