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

2004-04-26 Thread Riccardo Facchini
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;

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

2004-04-24 Thread Riccardo G. Facchini
--- Richard Huxton dev(at)archonet.com wrote: On Wednesday 21 April 2004 16:16, abief_ag_-postgresql(at)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;

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

2004-04-22 Thread Richard Huxton
On Wednesday 21 April 2004 16:16, [EMAIL PROTECTED] 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

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

2004-04-21 Thread 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'