Results 1 to 2 of 2

Thread: New.tg_argv[1]

  1. #1
    Join Date
    Jan 2002
    Posts
    19

    Question Unanswered: New.tg_argv[1]

    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.

  2. #2
    Join Date
    Sep 2001
    Location
    Vienna
    Posts
    400

    Problem

    Have you some inherited things in your datadase?

    It's hard to give a solution when I'm not seeing whats behind

    Eperich
    http://www.postgresql.org
    --Postgresql is the only kind of thing--

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •