| From: | Mladen Gogala <mgogala(at)vmsinfo(dot)com> |
|---|---|
| To: | Rob Richardson <Rob(dot)Richardson(at)rad-con(dot)com> |
| Cc: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: logging table changes |
| Date: | 2010-09-09 17:50:58 |
| Message-ID: | 4C891E82.7040204@vmsinfo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Rob Richardson wrote:
>
> But how is that significantly better than an update trigger that
> includes:
>
> If old.value <> new.value then
> do something
> End if
>
> RobR
>
>
It's better because the new version will not fire unless the "WHEN"
condition is satisfied, which means that you will save a few trigger
invocations, which should improve the performance. The present method
would fire every time, and check for the values.
--
Mladen Gogala
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
http://www.vmsinfo.com
The Leader in Integrated Media Intelligence Solutions
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rob Richardson | 2010-09-09 18:31:35 | Re: logging table changes |
| Previous Message | Rob Richardson | 2010-09-09 17:48:13 | Re: logging table changes |