trigger, how to determine action calling?

From: Marcin Mazurek <M(dot)Mazurek(at)poznan(dot)multinet(dot)pl>
To: pgsql-general(at)postgresql(dot)org
Subject: trigger, how to determine action calling?
Date: 2000-08-31 08:22:10
Message-ID: 20000831102210.E28551@poznan.mtl.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
Is it possible to determine easily which action called triger?
For example:
CREATE TRIGGER log_znw BEFORE INSERT OR UPDATE ON tab
FOR EACH ROW EXECUTE PROCEDURE log_tab();
How to check in called function if it was INSERT or UPDATE?

tia

Marcin Mazurek

--
Kierownik Działu Systemowego
MULTINET SA o/Poznan
http://www.multinet.pl/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Yury Don 2000-08-31 08:55:05 Re: trigger, how to determine action calling?
Previous Message pawel 2000-08-31 08:01:19 Re: LEFT OUTER JOINS