kalman
01-07-02, 06:45
| Hi guys. Anyone now how I can retrieve inside a trigger function the value NEW.TG_ARGV[1] ?? I tried with some like: my_stm := ''SELECT id_key AS res FROM '' || TG_ARGV[0] || '' WHERE '' || ''id_key = NEW.'' || quote_ident(TG_ARGV[1]); end after with a FOR ... EXECUTE but I receive the error that I'm using NEW in a non rule function..... Why also the NEW don't have the field oid ? Thank you in advance. Gaetano. |