From kc@avsupport.com Sun Aug 20 15:58:12 2000 Received: from mail.avsupport.com (mail.avsupport.com [207.70.233.2]) by hub.org (8.10.1/8.10.1) with SMTP id e7KFwCm35505 for ; Sun, 20 Aug 2000 11:58:12 -0400 (EDT) Received: from homebox.farcpe.cableone.net (homebox.farcpe.cableone.net [24.116.47.18]) by mail.avsupport.com (NTMail 3.03.0018/4c.adew) with ESMTP id ca603462 for ; Sun, 20 Aug 2000 10:58:55 -0500 Message-ID: <000601c00ac0$081275c0$122f7418@avsupport.com> From: "k.c. hemelstrand" To: Subject: update syntax error? Date: Tue, 15 Aug 2000 22:22:08 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0007_01C00707.40311D60" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200008/194 This is a multi-part message in MIME format. ------=_NextPart_000_0007_01C00707.40311D60 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Can anybody help with why I am receiving the error below? Thanks K.C. parts=3D# \d av_parts Table "av_parts" Attribute | Type | Modifier=20=20= =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20 ---------------------+-------------+---------------------------------------= ---------------- itemid | integer | not null default nextval('av_parts_ite= mid_seq'::text) vendorid | integer |=20 partnumber | varchar(25) |=20 alternatepartnumber | varchar(25) |=20 nsn | varchar(15) |=20 description | varchar(50) |=20 condition | varchar(10) |=20 quantity | integer |=20 rawpartnumber | varchar(25) |=20 rawalternatenumber | varchar(25) |=20 rawnsnnumber | varchar(15) |=20 date | integer |=20 cagecode | varchar(10) |=20 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=3D# UPDATE av_parts parts-# SET rawalternaternumber =3D 'NULL' AND alternatepartnumber =3D 'NUL= L' parts-# WHERE rawalternatenumber =3D 'IVA81A'; ERROR: left-hand side of AND is type 'unknown', not 'bool' ------=_NextPart_000_0007_01C00707.40311D60 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Can anybody help with why I am receiving the error=20 below?
 
Thanks
K.C.
 
 
parts=3D# \d=20 av_parts
          &nb= sp;            =             &nb= sp;=20 Table "av_parts"
     =20 Attribute      |   =20 Type    =20 |            &n= bsp;         =20 Modifier           &= nbsp;           =20
---------------------+-------------+-----------------------------------= --------------------
 itemid      &nb= sp;      =20 | integer     | not null default=20 nextval('av_parts_itemid_seq'::text)
 vendorid   &nb= sp;       =20 | integer     |=20
 partnumber          = |=20 varchar(25) |
 alternatepartnumber | varchar(25) |=20
 nsn          &n= bsp;     =20 | varchar(15) |=20
 description         |=20 varchar(50) |=20
 condition         &n= bsp;=20 | varchar(10) |=20
 quantity         &nb= sp; =20 | integer     |=20
 rawpartnumber       | varchar(25) |= =20
 rawalternatenumber  | varchar(25) |=20
 rawnsnnumber        | varchar(= 15) |=20
 date          &= nbsp;    =20 | integer     |=20
 cagecode         &nb= sp; =20 | varchar(10) |
Indices:=20 av_parts_alternatepartnumber_in,
      &nb= sp; =20 av_parts_itemid_key,
        =20 av_parts_nsn_index,
        =20 av_parts_partnumber_index,
       &nb= sp;=20 av_parts_rawalternatenumber_ind,
      &nb= sp; =20 av_parts_rawnsnnumber_index,
       &= nbsp;=20 av_parts_rawpartnumber_index,
       =  =20 av_parts_vendorid_index
 

parts=3D# UPDATE av_parts
parts-# SET rawalterna= ternumber=20 =3D 'NULL' AND alternatepartnumber =3D 'NULL'
parts-# WHERE rawalternate= number =3D=20 'IVA81A';
ERROR:  left-hand side of AND is type 'unknown', not=20 'bool'
------=_NextPart_000_0007_01C00707.40311D60-- From scrappy@hub.org Sun Aug 20 19:27:23 2000 Received: from thelab.hub.org (root@nat194.159.mpoweredpc.net [142.177.194.159]) by hub.org (8.10.1/8.10.1) with ESMTP id e7KJRNm92111 for ; Sun, 20 Aug 2000 15:27:23 -0400 (EDT) Received: from localhost (scrappy@localhost) by thelab.hub.org (8.9.3/8.9.3) with ESMTP id QAA50302; Sun, 20 Aug 2000 16:27:17 -0300 (ADT) (envelope-from scrappy@hub.org) X-Authentication-Warning: thelab.hub.org: scrappy owned process doing -bs Date: Sun, 20 Aug 2000 16:27:17 -0300 (ADT) From: The Hermit Hacker To: "k.c. hemelstrand" cc: pgsql-sql@postgresql.org Subject: Re: update syntax error? In-Reply-To: <000601c00ac0$081275c0$122f7418@avsupport.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200008/196 UPDATE SET field1=,field2= 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 From mikeo@spectrumtelecorp.com Mon Aug 21 14:06:26 2000 Received: from gw.spectrumtelecorp.com (216-064-054-021.inaddr.vitts.com [216.64.54.21]) by hub.org (8.10.1/8.10.1) with ESMTP id e7LE6QT53743 for ; Mon, 21 Aug 2000 10:06:26 -0400 (EDT) Received: from spec34 (spec34.spectrumtelecorp.com [192.168.1.67]) by gw.spectrumtelecorp.com (8.9.3/8.8.7) with SMTP id JAA27974; Mon, 21 Aug 2000 09:11:19 -0400 Message-Id: <3.0.1.32.20000821102024.009316e0@pop.spectrumtelecorp.com> X-Sender: mikeo@pop.spectrumtelecorp.com X-Mailer: Windows Eudora Pro Version 3.0.1 (32) Date: Mon, 21 Aug 2000 10:20:24 -0400 To: The Hermit Hacker , "k.c. hemelstrand" From: mikeo Subject: Re: update syntax error? Cc: pgsql-sql@postgresql.org In-Reply-To: References: <000601c00ac0$081275c0$122f7418@avsupport.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" X-Archive-Number: 200008/200 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
SET field1=,field2= > >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 >