Re: Trigger calling a function HELP ME! (2) - Mailing list pgsql-sql

On Wednesday 21 April 2004 16:16, abief_ag_-postgresql@yahoo.com wrote:

>   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;

This is your problem. NEW is a special variable, and I don't think you can 
pass it into another function (other than as NEW.col1, NEW.col2, NEW.col3 
etc).

You can however use TG_NAME or TG_RELNAME to see what trigger/table called 
you. I find that's helpful.
--  Richard Huxton Archonet Ltd