Re: Updating
От | Bob Pawley |
---|---|
Тема | Re: Updating |
Дата | |
Msg-id | 013301c887c6$f4bf9610$6401a8c0@owner обсуждение исходный текст |
Ответ на | Updating (Bob Pawley <rjpawley@shaw.ca>) |
Ответы |
Re: Updating
Re: Updating |
Список | pgsql-general |
Would it be possible to get an example of such coding?? Bob ----- Original Message ----- From: "Adrian Klaver" <aklaver@comcast.net> To: <pgsql-general@postgresql.org> Cc: "Bob Pawley" <rjpawley@shaw.ca> Sent: Sunday, March 16, 2008 5:14 PM Subject: Re: [GENERAL] Updating > On Sunday 16 March 2008 3:32 pm, Bob Pawley wrote: >> Is there a method available for triggering a function after an update on >> a >> particular column in a table? >> >> The only way that I have found is to trigger after an update on the whole >> table, which of course can lead to problems. >> >> Bob > > I trigger can be constrained to fire for each row. Inside the trigger > function > you can test to see if the column in question has been updated and do the > appropriate thing. If the column has not been changed do nothing and > RETURN > NEW which makes the function non-op. > -- > Adrian Klaver > aklaver@comcast.net > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general
В списке pgsql-general по дате отправления: