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
---------------------------------
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