Postgres Pro
Downloads
Home   >   mailing lists

trigger, how to determine action calling? - Mailing list pgsql-general

From Marcin Mazurek
Subject trigger, how to determine action calling?
Date
Msg-id 20000831102210.E28551@poznan.mtl.pl
Whole thread Raw
Responses Re: trigger, how to determine action calling?  (Yury Don <yura@vpcit.ru>)
List pgsql-general
Tree view 
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/

pgsql-general by date:

Previous
From: pawel
Date:
Subject: Re: LEFT OUTER JOINS
Next
From: Yury Don
Date:
Subject: Re: trigger, how to determine action calling?