Received: from localhost.localdomain (h246.ozemail2.ozemail.com.au [203.108.14.246]) by hub.org (8.9.3/8.9.3) with ESMTP id BAA28775 for ; Wed, 19 May 1999 01:06:09 -0400 (EDT) (envelope-from chris.bitmead@bigfoot.com) Received: from bigfoot.com (localhost [127.0.0.1]) by localhost.localdomain (8.8.7/8.8.7) with ESMTP id PAA10577 for ; Wed, 19 May 1999 15:08:19 +1000 Sender: chris@localhost.localdomain Message-ID: <37424742.925A3EA3@bigfoot.com> Date: Wed, 19 May 1999 05:08:18 +0000 From: Chris Bitmead X-Mailer: Mozilla 4.51 [en] (X11; I; Linux 2.2.6 i686) X-Accept-Language: en MIME-Version: 1.0 CC: pgsql-sql@postgreSQL.org Subject: Re: [SQL] Why wont this update work? References: <008d01bea1b2$fc0fd820$1a6001cb@chalmers.com.au> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Well "language" is an SQL reserved word. In Postgres it is a non-reserved key word, so it's probably not the problem but it may be worth seeing if changing the field name helps. Robert Chalmers wrote: > > Hi, > trying to get this to work with pgsql, but it refuses to do anything... > > the table is called catalog. The field is called language and is a > varchar(3) field. > 81 of the records have the letter 'E' in the language field. i want to > put 'NoD' in the rest. > > UPDATE catalog > SET language = 'NoD' > WHERE NOT language = 'E'; > > nor does > > UPDATE catalog > SET language = 'NoD' > WHERE language = 'NULL'; ........ or NULL and so on. > > I can change the 81 letter 'E's to anything I like, but can not UPDATE the > blank fields.. > > can anyone tell me what I am missing here please? > > Thanks > Bob > > --- http://4qir.quantum-radio.net.au - Where Only The Dedicated Survive! > 4QIR Quantum Radio. Bringing you the original sounds of AFVN, with some of > the > original DJ's - back on air - and supporting not only the original Vets, in > comprehensive AFVN Archives, but putting together segments for the fighting > men and > women of todays services all around the world. World Music, for people of > the world.