Postgres Pro
Downloads
Home   >   mailing lists

obtaining the query string inside a trigger - Mailing list pgsql-sql

From Gerardo Herzig
Subject obtaining the query string inside a trigger
Date
Msg-id 478D25B7.8030308@fmed.uba.ar
Whole thread Raw
Responses Re: obtaining the query string inside a trigger  (Richard Huxton <dev@archonet.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: "Rodrigo E. De León Plicet"
Date:
Subject: Re: SQL dealing with subquery
Next
From: Richard Huxton
Date:
Subject: Re: obtaining the query string inside a trigger