Minor change for UPDATE

Started by Daniele Orlandialmost 27 years ago1 messages
#1Daniele Orlandi
daniele@orlandi.com

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.com
Via Mezzera 29/A - 20030 - Seveso (MI) - Italy
-------------------------------------------------------------------------------