[SQL] Trigger calling a function HELP ME! (2)

[abief_ag_-postgresql]

Sorry. I realize I slipped an error in my code:
 
 the code is:
 ---
  CREATE TABLE public.imp_test
  (
    id int8,
    value text
  ) WITHOUT OIDS;
  
  CREATE OR REPLACE FUNCTION public.imp_test_to_out_test(imp_test)
    RETURNS imp_test AS
  'begin
   return $1;
 end;'
    LANGUAGE 'plpgsql' STABLE;
  
  CREATE OR REPLACE FUNCTION public.imp_test_trigger()
    RETURNS trigger AS
  'begin
  return imp_test_to_out_test(new);
  end;'
    LANGUAGE 'plpgsql' STABLE;
  
  CREATE TRIGGER imp_test_trigger_001
    BEFORE INSERT OR UPDATE
    ON public.imp_test
    FOR EACH ROW
    EXECUTE PROCEDURE public.imp_test_trigger();
 ---
 
 regards,
 


=====
Riccardo G. Facchini

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings