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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-sql by date

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