Date: Tue, 27 Aug 2002 18:18:07 +0200
From: Mathieu Arnold <mat@mat.cc>
To: pgsql-sql@postgresql.org
Subject: triggers and plpgsql question
Message-ID: <374862253.1030472287@andromede.reaumur.absolight.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi

I want to do a generic function that I can add to triggers to add every
inserts, updates and deletes from many differents tables into a common
format in another table. the idea is :

create function do_it_all () returns opaque '
begin
  IF TG_OP = ''INSERT'' THEN
    cycle through all of NEW (not knowing what it contains) and do things
      with them
  ELSIF TG_OP = ''UPDATE'' THEN
    cycle through all of NEW (not knowing what it contains) and do things
      with them
  ELSIF TG_OP = ''DELETE'' THEN
    say that NEW.id_||TG_RELNAME has been deleted
  END IF;
END;

The thing I need, is to be able to know what does NEW contains, and I have
not found out any mean to do so. If it's not possible to do so, I'll write
a function per table, but for the beauty of all this, I would have liked to
do it the way above.

-- 
Mathieu Arnold