Received: from frank.wiles.org (frank.wiles.org [24.124.35.230]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9TGjwP02989 for ; Mon, 29 Oct 2001 11:45:58 -0500 (EST) (envelope-from frank@frank.wiles.org) Received: (from frank@localhost) by frank.wiles.org (8.11.6/8.11.6) id f9TGoRN03729; Mon, 29 Oct 2001 10:50:27 -0600 Date: Mon, 29 Oct 2001 10:50:27 -0600 From: Frank Wiles To: stephen Cc: pgsql-sql@postgresql.org Subject: Re: delete queires Message-ID: <20011029105027.U6370@frank.wiles.org> References: <000801c15f2c$2ff6fcc0$5b0e7ad5@r355000075> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <000801c15f2c$2ff6fcc0$5b0e7ad5@r355000075>; from stephen.hubbard@btinternet.com on Sat, Oct 27, 2001 at 10:13:10PM +0100 X-Archive-Number: 200110/393 X-Sequence-Number: 5345 .------[ stephen wrote (2001/10/27 at 22:13:10) ]------ | | 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? | | Is there a macro or module code i could use? your help would be much | appreciated | `------------------------------------------------- No you can't delete a field, delete is only for entire rows. What you'll want to do is UPDATE the field(s) in question to NULLs. --------------------------------- Frank Wiles http://frank.wiles.org ---------------------------------