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

From
Subject Trigger calling a function HELP ME! (2)
Date
Msg-id 20040421151605.77039.qmail@web13901.mail.yahoo.com
Whole thread Raw
Responses Re: Trigger calling a function HELP ME! (2)  (Richard Huxton <dev@archonet.com>)
List pgsql-sql
Sorry. I realize I slipped an error in my code:the code is:--- CREATE TABLE public.imp_test (   id int8,   value text )
WITHOUTOIDS;  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
returnimp_test_to_out_test(new); end;'   LANGUAGE 'plpgsql' STABLE;  CREATE TRIGGER imp_test_trigger_001   BEFORE
INSERTOR UPDATE   ON public.imp_test   FOR EACH ROW   EXECUTE PROCEDURE public.imp_test_trigger();---regards,
 


=====
Riccardo G. Facchini


pgsql-sql by date:

Previous
From: Edmund Bacon
Date:
Subject: Re: Order by YYYY MM DD in reverse chrono order trouble
Next
From: Bruno Wolff III
Date:
Subject: Re: transaction