Skip site navigation (1) Skip section navigation (2)

obtaining the query string inside a trigger

From: Gerardo Herzig <gherzig(at)fmed(dot)uba(dot)ar>
To: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: obtaining the query string inside a trigger
Date: 2008-01-15 21:29:27
Message-ID: 478D25B7.8030308@fmed.uba.ar (view raw or flat)
Thread:
Lists: pgsql-sql
Hi all. Im working on a "on each statement" update trigger, so NEW and 
OLD are NULL.
Suppose a simple query like 'update mytable set id=id+500 where id < 
50'...There is a way to obtaining the 'set id=..' and the where clause
in some way?

Thanks!
Gerardo

Responses

pgsql-sql by date

Next:From: Richard HuxtonDate: 2008-01-16 09:21:37
Subject: Re: obtaining the query string inside a trigger
Previous:From: Franklin HautDate: 2008-01-15 21:03:49
Subject: Update PK Violation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group