Re: DELETE FROM error message
От | Robert Treat |
---|---|
Тема | Re: DELETE FROM error message |
Дата | |
Msg-id | 1026995412.22899.1.camel@camel обсуждение исходный текст |
Ответ на | Re: DELETE FROM error message (Darren Ferguson <darren@crystalballinc.com>) |
Ответы |
Re: DELETE FROM error message
|
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: