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 >