Minor change for UPDATE - Mailing list pgsql-hackers

From Daniele Orlandi
Subject Minor change for UPDATE
Date
Msg-id 36B87B1B.6A7C783A@orlandi.com
Whole thread Raw
List pgsql-hackers
Hi,

I sometimes need to update records without a SET clause, just to fire a trigger
that actually changes the tuple.

Currently I do:

UPDATE relation SET anyfield=anyfield WHERE whereclause;

It would be nice to be able to do:

UPDATE relation WHERE whereclause;

I don't know if this will break something, and I'd like to make the change
myself, but I'm still a newbie in the postgres internals. Please consider it a
lowest-priority entry to be put in the whis-list :^)

Thanks!

Bye!

-- Daniele

-------------------------------------------------------------------------------Daniele Orlandi - Utility Line Italia -
http://www.orlandi.comViaMezzera 29/A - 20030 - Seveso (MI) - Italy
 
-------------------------------------------------------------------------------


pgsql-hackers by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: [HACKERS] 6.5 beta and ORDER BY patch
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] template/alpha_cc