Received: from megazone.bigpanda.com ([63.150.15.178]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9THjwP21380 for ; Mon, 29 Oct 2001 12:45:58 -0500 (EST) (envelope-from sszabo@megazone23.bigpanda.com) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id EAA95D5CB; Mon, 29 Oct 2001 09:45:56 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id DE5865BD0; Mon, 29 Oct 2001 09:45:56 -0800 (PST) Date: Mon, 29 Oct 2001 09:45:56 -0800 (PST) From: Stephan Szabo To: stephen Cc: Subject: Re: delete queires In-Reply-To: <000801c15f2c$2ff6fcc0$5b0e7ad5@r355000075> Message-ID: <20011029094358.Y9662-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200110/398 X-Sequence-Number: 5350 On Sat, 27 Oct 2001, stephen wrote: > i was wondering if it's possible to make a delete query to delete only > one of the two fields in a table. I have tried only putting that > field as the "from" but it still deletes the other field also? AFAIK delete works on entire rows. What is it you want it to do preciselfy? If you want to set the other value to null, an update is probably really what you want.