| From: | James Thornton <thornton(at)cs(dot)baylor(dot)edu> |
|---|---|
| To: | Gregory Wood <gregw(at)com-stock(dot)com> |
| Cc: | PostgreSQL-General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: update returns 1, but no changes have been made |
| Date: | 2001-12-04 13:29:23 |
| Message-ID: | 3C0CCFB3.5A9C614B@cs.baylor.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
Gregory Wood wrote:
> If you return old from an UPDATE, no changes are made (it takes the old
> values and puts them into the database rather than your new values). Of
> course you need to return old from a DELETE (new doesn't exist in a delete
> trigger)...
That was it -- thanks for your help Gregory.
JT
________________________________________
James Thornton, http://jamesthornton.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fariba Noorbakhsh | 2001-12-04 14:35:32 | Remote Access to pgsql DB ??? |
| Previous Message | Martijn van Oosterhout | 2001-12-04 13:00:54 | Re: Backends staying around |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roland Roberts | 2001-12-04 14:47:13 | Re: Need help with a college SQL exam question... |
| Previous Message | James Thornton | 2001-12-04 11:57:42 | Re: update returns 1, but no changes have been made |