| From: | Frank Wiles <frank(at)wiles(dot)org> |
|---|---|
| To: | stephen <stephen(dot)hubbard(at)btinternet(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: delete queires |
| Date: | 2001-10-29 16:50:27 |
| Message-ID: | 20011029105027.U6370@frank.wiles.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
.------[ 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(at)wiles(dot)org>
http://frank.wiles.org
---------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ross J. Reedstrom | 2001-10-29 17:35:37 | Re: delete queires |
| Previous Message | Josh Berkus | 2001-10-29 16:35:13 | Re: oid's in views. |