Обсуждение: Minor change for UPDATE

Поиск
Список
Период
Сортировка

Minor change for UPDATE

От
Daniele Orlandi
Дата:
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
 
-------------------------------------------------------------------------------