[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-sql
Subject:    Re: [SQL] delete queires
From:       Stephan Szabo <sszabo () megazone23 ! bigpanda ! com>
Date:       2001-10-29 17:45:56
[Download RAW message or body]

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.


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

[prev in list] [next in list] [prev in thread] [next in thread]