Re: update returns 1, but no changes have been made - Mailing list pgsql-general

From James Thornton
Subject Re: update returns 1, but no changes have been made
Date
Msg-id 3C0CCFB3.5A9C614B@cs.baylor.edu
Whole thread Raw
In response to update returns 1, but no changes have been made  (James Thornton <thornton@cs.baylor.edu>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "Travis Bear"
Date:
Subject: use BLOBS or use pointers to files on the filesystem?
Next
From: mgundlach@comosoft.de (Michael Gundlach)
Date:
Subject: Re: Large tables management question