Minor change for UPDATE

Поиск
Список
Период
Сортировка
От Daniele Orlandi
Тема Minor change for UPDATE
Дата
Msg-id 36B87B1B.6A7C783A@orlandi.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: The Hermit Hacker
Дата:
Сообщение: Re: [HACKERS] 6.5 beta and ORDER BY patch
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] template/alpha_cc