From: Gerardo Herzig <gherzig@fmed.uba.ar>
To: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: obtaining the query string inside a trigger
Date: Tue, 15 Jan 2008 18:29:27 -0300
Message-ID: <478D25B7.8030308@fmed.uba.ar> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: gherzig@fmed.uba.ar
Subject: Re: obtaining the query string inside a trigger
In-Reply-To: <478D25B7.8030308@fmed.uba.ar>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox