Thread
-
update syntax error?
k.c. hemelstrand <kc@avsupport.com> — 2000-08-16T03:22:08Z
Can anybody help with why I am receiving the error below? Thanks K.C. parts=# \d av_parts Table "av_parts" Attribute | Type | Modifier ---------------------+-------------+------------------------------------------------------- itemid | integer | not null default nextval('av_parts_itemid_seq'::text) vendorid | integer | partnumber | varchar(25) | alternatepartnumber | varchar(25) | nsn | varchar(15) | description | varchar(50) | condition | varchar(10) | quantity | integer | rawpartnumber | varchar(25) | rawalternatenumber | varchar(25) | rawnsnnumber | varchar(15) | date | integer | cagecode | varchar(10) | Indices: av_parts_alternatepartnumber_in, av_parts_itemid_key, av_parts_nsn_index, av_parts_partnumber_index, av_parts_rawalternatenumber_ind, av_parts_rawnsnnumber_index, av_parts_rawpartnumber_index, av_parts_vendorid_index parts=# UPDATE av_parts parts-# SET rawalternaternumber = 'NULL' AND alternatepartnumber = 'NULL' parts-# WHERE rawalternatenumber = 'IVA81A'; ERROR: left-hand side of AND is type 'unknown', not 'bool' -
Re: update syntax error?
Marc G. Fournier <scrappy@hub.org> — 2000-08-20T19:27:17Z
UPDATE <table> SET field1=<value>,field2=<value> On Tue, 15 Aug 2000, k.c. hemelstrand wrote: > Can anybody help with why I am receiving the error below? > > Thanks > K.C. > > > parts=# \d av_parts > Table "av_parts" > Attribute | Type | Modifier > ---------------------+-------------+------------------------------------------------------- > itemid | integer | not null default nextval('av_parts_itemid_seq'::text) > vendorid | integer | > partnumber | varchar(25) | > alternatepartnumber | varchar(25) | > nsn | varchar(15) | > description | varchar(50) | > condition | varchar(10) | > quantity | integer | > rawpartnumber | varchar(25) | > rawalternatenumber | varchar(25) | > rawnsnnumber | varchar(15) | > date | integer | > cagecode | varchar(10) | > Indices: av_parts_alternatepartnumber_in, > av_parts_itemid_key, > av_parts_nsn_index, > av_parts_partnumber_index, > av_parts_rawalternatenumber_ind, > av_parts_rawnsnnumber_index, > av_parts_rawpartnumber_index, > av_parts_vendorid_index > > > parts=# UPDATE av_parts > parts-# SET rawalternaternumber = 'NULL' AND alternatepartnumber = 'NULL' > parts-# WHERE rawalternatenumber = 'IVA81A'; > ERROR: left-hand side of AND is type 'unknown', not 'bool' > Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org -
Re: update syntax error?
mikeo <mikeo@spectrumtelecorp.com> — 2000-08-21T14:20:24Z
query should have a comma instead of the word and... HTH mikeo At 04:27 PM 8/20/00 -0300, The Hermit Hacker wrote: > >UPDATE <table> SET field1=<value>,field2=<value> > >On Tue, 15 Aug 2000, k.c. hemelstrand wrote: > >> Can anybody help with why I am receiving the error below? >> >> Thanks >> K.C. >> >> >> parts=# UPDATE av_parts >> parts-# SET rawalternaternumber = 'NULL' AND alternatepartnumber = 'NULL' >> parts-# WHERE rawalternatenumber = 'IVA81A'; >> ERROR: left-hand side of AND is type 'unknown', not 'bool' >> > >Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy >Systems Administrator @ hub.org >primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org >