[postgis-users] trigger function

[Daniel Grum]

is there a way to build a simple INSERT trigger function like that:

CREATE OR REPLACE FUNCTION einheitenstandort()
  RETURNS trigger AS
$BODY$ 
   BEGIN

    INSERT INTO einheitenstandort
    SELECT         nextval('serial') AS GID,
            startpoint(line.the_geom) AS the_geom,
            line.name_der_einheit AS name_der_einheit,
            line.art AS art,
            (SELECT a.geschwindigkeit WHERE line.art = a.art) AS 
geschwindigkeit,
            localtimestamp AS zeitpunkt
    FROM    public.einheiten_und_bewegungen line, public.art_der_einheit 
a, public.einheitenstandort es;
           
   END; $BODY$
  LANGUAGE 'plpgsql' VOLATILE
  COST 1000;
ALTER FUNCTION einheitenstandort() OWNER TO postgres;

Or are more infos need to be in the triggerfunction????

The trigger of the table einheiten_und_bewegungen is:

  CREATE TRIGGER my_trigger
  AFTER INSERT OR UPDATE OR DELETE
  ON einheiten_und_bewegungen
  FOR EACH ROW
  EXECUTE PROCEDURE einheitenstandort();

The idea is, that everytime when a new "einheitenbewegung" was digitized 
over the WFS-T an INSERT was made in the table einheitenstandort-->the 
actual position of the unit.

Thanks for all ideas!
--daniel