pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Frank Wiles <frank@wiles.org>
To: stephen <stephen.hubbard@btinternet.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: delete queires
Date: Mon, 29 Oct 2001 10:50:27 -0600
Message-ID: <20011029105027.U6370@frank.wiles.org> (raw)
In-Reply-To: <000801c15f2c$2ff6fcc0$5b0e7ad5@r355000075>
References: <000801c15f2c$2ff6fcc0$5b0e7ad5@r355000075>

 .------[ 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 <frank@wiles.org>
   http://frank.wiles.org
 ---------------------------------




view thread (4+ messages)  latest in thread

Message-ID: <20011029105027.U6370@frank.wiles.org>
Permalink:  ../20011029105027.U6370@frank.wiles.org/
Also on:    postgresql.org/message-id/20011029105027.U6370@frank.wiles.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: frank@wiles.org, stephen.hubbard@btinternet.com
  Subject: Re: delete queires
  In-Reply-To: <20011029105027.U6370@frank.wiles.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox