obtaining the query string inside a trigger

От:

Gerardo Herzig <gherzig@fmed.uba.ar>

Дата:

15 января 2008 г. в 17:27:29

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

Re: obtaining the query string inside a trigger

От:

Richard Huxton <dev@archonet.com>

Дата:

16 января 2008 г. в 05:21:49

Gerardo Herzig wrote:
> 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?

Afraid not. It might be possible to implement in the simple case, but 
what with views rewriting queries and triggers issuing their own 
secondary queries it's not always obvious what "the" query would be.

What we really need is NEW and OLD as sets of affected rows in 
statement-queries. Unfortunately that's not implemented yet either - 
it's on the TODO I believe though.

--   Richard Huxton  Archonet Ltd