| From: | "Raymond Chui" <Raymond(dot)Chui(at)noaa(dot)gov> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org, pgadmin-support(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org |
| Subject: | How to execute my trigger when update certain columns but not all? |
| Date: | 2002-08-14 12:09:36 |
| Message-ID: | 3D5A487F.ECFECBAE@noaa.gov |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support pgsql-admin pgsql-general pgsql-sql |
Let say I have a table has column1 and column2 and I made a trigger for
after INSERT OR UPDATE for each row to execute procedure my_function.
What I want is the trigger execute my_function only when column1 is
insert or
update, but not going to execute my_function when column2 is insert or
update.
How do I do that?
Thank Q very much
| Attachment | Content-Type | Size |
|---|---|---|
| raymond.chui.vcf | text/x-vcard | 312 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2002-08-14 13:11:56 | Re: BUG - does not handle empty strings properly |
| Previous Message | Dave Page | 2002-08-14 07:51:20 | Re: download broken |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Curt Sampson | 2002-08-14 12:43:06 | Re: performance tuning: shared_buffers, sort_mem; swap |
| Previous Message | Tom Lane | 2002-08-14 03:35:49 | Re: performance tuning: shared_buffers, sort_mem; swap |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tommi Maekitalo | 2002-08-14 12:13:55 | Re: Sourceforge moving to DB2 |
| Previous Message | Jules Alberts | 2002-08-14 11:13:22 | Re: opaque function not accepted (without error message) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sugandha Shah | 2002-08-14 12:26:16 | parser: parse error at or near "$1" |
| Previous Message | Richard Huxton | 2002-08-14 11:10:29 | Re: Explicite typecasting of functions |